Sample

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

sha256:ff6af08598a4e3fc137ed941f6d4febe37974700677148ef2b547bef8cdf052c

Case

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 HOW

Packages

github.com/jackc/pgx/v5 v5.10.0

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

Download the verified artifact (tar.gz) — the exact bytes the contract ran against

Origin Seeder

csx-seed

Verification receipts

• go 1.26 · CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · golang@1 · 2026-08-16 · ed25519:d91480838ac982c9