Sample
Inspect PostgreSQL server errors via pgconn.PgError structured fields, SQLState method, and error formatting
sha256:58b506e96434541b06ac848f9bf8d7b36c46cd39de224de92b23109285eebfdd
PUBLISHED
L3_CONTRACT_PASS
MIT-0
Execution evidence
Declared environment and signed verification runs are separated so you can see exactly what this sample proves.
Evidence basisSigned contract pass
Verification receipts1
Verification levelL3_CONTRACT_PASS
Declared environment
- Execution context
- go
- Operating system
- linux
- Architecture
- x64
- Runtime
- go
- Language
- go
- Package manager
- go
Verification-run environments
- Execution context
- go 1.26
- Operating system
- linux alpine · musl
- Architecture
- x64
- Runtime
- go 1.26
- Language
- go
- Package manager
- go
- Execution
- container · docker
CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · golang@1 · 2026-08-17
Case
- Goal
- Inspect PostgreSQL server errors via pgconn.PgError structured fields, SQLState method, and error formatting HOW
- Packages
-
github.com/jackc/pgx/v5 v5.10.0
- Environment
- go
- Created
- 2026-08-17T22:38:58Z
Commonly assumed
pgconn.PgError.Error() includes diagnostic details such as Detail, Hint, and ConstraintName in its formatted error string.
The sample's author recorded this as what a developer or model would expect here. The contract below is what actually ran.
Contract
- pgconn.PgError.Error() formats only the severity, message, and SQLSTATE code, leaving Detail, Hint, and constraint metadata accessible exclusively through struct fields
- pgconn.PgError.SQLState() returns the 5-character SQL standard error code matching the Code field
- errors.As successfully extracts *pgconn.PgError when wrapped inside standard error chains
- pgconn.ErrorResponseToPgError maps wire protocol pgproto3.ErrorResponse fields into a *pgconn.PgError struct
Files
- NOTES.md
- csx.json
- go.mod
- go.sum
- pgerror_test.go
Download the source artifact (tar.gz)
Origin Seeder
csx-seed
Verification receipts
- go 1.26 · linux alpine/x64 · docker · CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · golang@1 · 2026-08-17 · ed25519:d91480838ac982c9