Sample
github.com/jackc/pgx/v5 v5.10.0: Avoid DSN RuntimeParams pollution by distinguishing pgx and pgxpool ParseConfig, enforce Simple Protocol for multi-statement execution, and scan nullable array elements into pointer or pgtype slices
Verified sample for golang github.com/jackc/pgx/v5 v5.10.0: Avoid DSN RuntimeParams pollution by distinguishing pgx and pgxpool ParseConfig, enforce Simple…
sha256:ff6af08598a4e3fc137ed941f6d4febe37974700677148ef2b547bef8cdf052c
This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured.
How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people.
MIT-0
Execution evidence
The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.
- Evidence basis
- Signed contract pass
- Verification receipts
- 2
- Signing keys that built it
- 2
Declared environment
go linux x64 go go gomod
Verification-run environments
| Environment | Contract | Stages | Run |
|---|---|---|---|
| go 1.26 · linux alpine/x64 · docker ed25519:d91480838ac982c9 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · golang@1 |
2026-08-16 |
| go 1.26 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · golang@1 |
2026-08-18 |
Case
HOW- Goal
- Avoid DSN RuntimeParams pollution by distinguishing pgx and pgxpool ParseConfig, enforce Simple Protocol for multi-statement execution, and scan nullable array elements into pointer or pgtype slices
- Packages
- Symbols
-
- pgx.ParseConfig
- pgxpool.ParseConfig
- pgx.QueryExecMode
- pgx.Batch
- pgtype.FlatArray
- pgtype.Numeric
- Environment
- go
- Created
- 2026-08-16T06:22:07Z
Contract
- assert pgx.ParseConfig routes pool options into RuntimeParams while pgxpool.ParseConfig extracts them
- assert pgx.ParseConfig configures statement_cache_capacity and default_query_exec_mode without RuntimeParams pollution
- assert default QueryExecModeCacheStatement rejects multi-statement SQL strings while QueryExecModeSimpleProtocol succeeds
- assert scanning SQL arrays with NULL elements fails for []T but succeeds for []*T and []pgtype.Int4
- assert scanning SQL NULL array yields nil slice whereas SQL empty array {} yields non-nil slice
- assert pgtype.FlatArray flattens multi-dimensional PostgreSQL arrays into 1D Go slices
- assert pgx.Batch stops subsequent executions on query failure and BatchResults.Close returns the first error
- assert pgtype.Numeric handles fractional decimals, NaN, and Infinity modifiers without loss of precision
Files
- NOTES.md
- csx.json
- go.mod
- go.sum
- mock.go
- sample_test.go