MIME-Version: 1.0
From: Josh Kupershmidt <schmiddy@gmail.com>
Date: Wed, 1 Apr 2026 09:44:15 -0400
Message-ID: 
 <CAK3UJRGc2RKfQMjwVDAwsuOJuobq3d4+Qf9KWK1NHmK1vaqyxQ@mail.gmail.com>
Subject: Todo item: Include the symbolic SQLSTATE name in verbose error
 reports
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000007a2e79064e6648a7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAK3UJRGc2RKfQMjwVDAwsuOJuobq3d4%2BQf9KWK1NHmK1vaqyxQ%40mail.gmail.com>
Precedence: bulk

--0000000000007a2e79064e6648a7
Content-Type: multipart/alternative; boundary="0000000000007a2e77064e6648a5"

--0000000000007a2e77064e6648a5
Content-Type: text/plain; charset="UTF-8"

Hi,

Attached is a patch implementing an old feature request on the wiki's Todo:

"Include the symbolic SQLSTATE name in verbose error reports"

The output should only be different in verbose mode, i.e. if you:

  \set VERBOSITY verbose

The old output in verbose mode would look like:

  # SELECT * FROM nonexistent_table;
  ERROR:  42P01: relation "nonexistent_table" does not exist
  LINE 1: SELECT * FROM nonexistent_table;

  LOCATION:  parserOpenTable, parse_relation.c:1461

The new output looks like:

  # select * FROM nonexistent;
  ERROR:  42P01 (ERRCODE_UNDEFINED_TABLE): relation "nonexistent" does not
exist
  LINE 1: select * FROM nonexistent;
                      ^
  LOCATION:  parserOpenTable, parse_relation.c:1461

so that we tell the user clearly what "42P01" means, in this example.

Cheers,
Josh

--0000000000007a2e77064e6648a5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>Attached is a patch implementing=C2=
=A0an old feature request on the wiki&#39;s Todo:</div><div><br></div><div>=
&quot;Include the symbolic SQLSTATE name in verbose error reports&quot;</di=
v><div><br></div><div>The output should only be different in verbose mode, =
i.e. if you:</div><div><br></div><div>=C2=A0 \set VERBOSITY verbose</div><d=
iv><br></div><div>The old output in verbose mode would look like:</div><div=
><br></div><div>=C2=A0 # SELECT * FROM nonexistent_table;<br>=C2=A0 ERROR: =
=C2=A042P01: relation &quot;nonexistent_table&quot; does not exist<br>=C2=
=A0 LINE 1: SELECT * FROM nonexistent_table;<br></div><div><br></div><div>=
=C2=A0 LOCATION: =C2=A0parserOpenTable, parse_relation.c:1461<br></div><div=
><br></div><div>The new output looks like:</div><div><br></div><div>=C2=A0 =
# select * FROM nonexistent;<br>=C2=A0 ERROR: =C2=A042P01 (ERRCODE_UNDEFINE=
D_TABLE): relation &quot;nonexistent&quot; does not exist<br>=C2=A0 LINE 1:=
 select * FROM nonexistent;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ^<br>=C2=A0 LOCATION: =C2=A0parserOpenTa=
ble, parse_relation.c:1461<br></div><div><br></div><div>so that we tell the=
 user clearly what &quot;42P01&quot; means, in this example.</div><div><br>=
</div><div>Cheers,</div><div>Josh</div><div><br></div></div>

--0000000000007a2e77064e6648a5--

--0000000000007a2e79064e6648a7
Content-Type: application/octet-stream;
	name="include-symbolic-SQLSTATE-name-in-verbose-mode-output.patch"
Content-Disposition: attachment;
	filename="include-symbolic-SQLSTATE-name-in-verbose-mode-output.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mng3ho920>
X-Attachment-Id: f_mng3ho920

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL2VycmNvZGVzLnR4dCBiL3NyYy9iYWNrZW5k
L3V0aWxzL2VycmNvZGVzLnR4dAppbmRleCA1YjI1NDAyZWJiZS4uOThmZjY4OGVlMjcgMTAwNjQ0
Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL2VycmNvZGVzLnR4dAorKysgYi9zcmMvYmFja2VuZC91
dGlscy9lcnJjb2Rlcy50eHQKQEAgLTE4LDYgKzE4LDkgQEAKICMgICBzcmMvcGwvdGNsL3BsdGNs
ZXJyY29kZXMuaAogIyAgICAgIHRoZSBzYW1lLCBmb3IgUEwvVGNsCiAjCisjICAgc3JjL2ludGVy
ZmFjZXMvbGlicHEvc3Fsc3RhdGVfbmFtZXMuaAorIyAgICAgIGEgbG9va3VwIHRhYmxlIG1hcHBp
bmcgU1FMU1RBVEUgY29kZXMgdG8gc3ltYm9saWMgbmFtZXMgZm9yIGxpYnBxCisjCiAjICAgZG9j
L3NyYy9zZ21sL2VycmNvZGVzLXRhYmxlLnNnbWwKICMgICAgICBhIFNHTUwgdGFibGUgb2YgZXJy
b3IgY29kZXMgZm9yIGluY2x1c2lvbiBpbiB0aGUgZG9jdW1lbnRhdGlvbgogIwpkaWZmIC0tZ2l0
IGEvc3JjL2JhY2tlbmQvdXRpbHMvZ2VuZXJhdGUtc3Fsc3RhdGUtbmFtZXMucGwgYi9zcmMvYmFj
a2VuZC91dGlscy9nZW5lcmF0ZS1zcWxzdGF0ZS1uYW1lcy5wbApuZXcgZmlsZSBtb2RlIDEwMDY0
NAppbmRleCAwMDAwMDAwMDAwMC4uOTllN2E5YjM2YTYKLS0tIC9kZXYvbnVsbAorKysgYi9zcmMv
YmFja2VuZC91dGlscy9nZW5lcmF0ZS1zcWxzdGF0ZS1uYW1lcy5wbApAQCAtMCwwICsxLDEwMCBA
QAorIyEvdXNyL2Jpbi9wZXJsCisjCisjIEdlbmVyYXRlIHRoZSBzcWxzdGF0ZV9uYW1lcy5oIGhl
YWRlciBmcm9tIGVycmNvZGVzLnR4dAorIyBDb3B5cmlnaHQgKGMpIDIwMDAtMjAyNiwgUG9zdGdy
ZVNRTCBHbG9iYWwgRGV2ZWxvcG1lbnQgR3JvdXAKKwordXNlIHN0cmljdDsKK3VzZSB3YXJuaW5n
cyBGQVRBTCA9PiAnYWxsJzsKK3VzZSBHZXRvcHQ6Okxvbmc7CisKK215ICRvdXRmaWxlID0gJyc7
CisKK0dldE9wdGlvbnMoJ291dGZpbGU9cycgPT4gXCRvdXRmaWxlKSBvciBkaWUgIiQwOiB3cm9u
ZyBhcmd1bWVudHMiOworCitvcGVuIG15ICRlcnJjb2RlcywgJzwnLCAkQVJHVlswXQorICBvciBk
aWUgIiQwOiBjb3VsZCBub3Qgb3BlbiBpbnB1dCBmaWxlICckQVJHVlswXSc6ICQhXG4iOworCitt
eSAkb3V0Zmg7CitpZiAoJG91dGZpbGUpCit7CisJb3BlbiAkb3V0ZmgsICc+JywgJG91dGZpbGUK
KwkgIG9yIGRpZSAiJDA6IGNvdWxkIG5vdCBvcGVuIG91dHB1dCBmaWxlICckb3V0ZmlsZSc6ICQh
XG4iOworfQorZWxzZQoreworCSRvdXRmaCA9ICpTVERPVVQ7Cit9CisKK215IEBlbnRyaWVzOwor
Cit3aGlsZSAoPCRlcnJjb2Rlcz4pCit7CisJY2hvbXA7CisKKwkjIFNraXAgY29tbWVudHMgYW5k
IGVtcHR5IGxpbmVzCisJbmV4dCBpZiAvXiMvOworCW5leHQgaWYgL15ccyokLzsKKworCSMgU2tp
cCBzZWN0aW9uIGhlYWRlcnMKKwluZXh0IGlmIC9eU2VjdGlvbjovOworCisJZGllICJ1bmFibGUg
dG8gcGFyc2UgZXJyY29kZXMudHh0IgorCSAgdW5sZXNzIC9eKFteXHNdezV9KVxzK1tFV1NdXHMr
KFteXHNdKykvOworCisJcHVzaCBAZW50cmllcywgWyQxLCAkMl07Cit9CisKK2Nsb3NlICRlcnJj
b2RlczsKKworIyBTb3J0IGJ5IFNRTFNUQVRFCitAZW50cmllcyA9IHNvcnQgeyAkYS0+WzBdIGNt
cCAkYi0+WzBdIH0gQGVudHJpZXM7CisKK3ByaW50ICRvdXRmaCA8PCdIRUFERVInOworLyogYXV0
b2dlbmVyYXRlZCBmcm9tIHNyYy9iYWNrZW5kL3V0aWxzL2VycmNvZGVzLnR4dCwgZG8gbm90IGVk
aXQgKi8KKyNpZm5kZWYgU1FMU1RBVEVfTkFNRVNfSAorI2RlZmluZSBTUUxTVEFURV9OQU1FU19I
CisKKyNpbmNsdWRlIDxzdHJpbmcuaD4KKwordHlwZWRlZiBzdHJ1Y3QKK3sKKwljb25zdCBjaGFy
IHNxbHN0YXRlWzZdOworCWNvbnN0IGNoYXIgKnN5bWJvbGljX25hbWU7Cit9IFNxbHN0YXRlTmFt
ZUVudHJ5OworCitzdGF0aWMgY29uc3QgU3Fsc3RhdGVOYW1lRW50cnkgc3Fsc3RhdGVfbmFtZV90
YWJsZVtdID0geworSEVBREVSCisKK2ZvciBteSAkZSAoQGVudHJpZXMpCit7CisJcHJpbnQgJG91
dGZoICJcdHtcIiRlLT5bMF1cIiwgXCIkZS0+WzFdXCJ9LFxuIjsKK30KKworcHJpbnQgJG91dGZo
IDw8J0ZPT1RFUic7Cit9OworCitzdGF0aWMgaW5saW5lIGNvbnN0IGNoYXIgKgorc3Fsc3RhdGVf
dG9fc3ltYm9saWNfbmFtZShjb25zdCBjaGFyICpzcWxzdGF0ZSkKK3sKKwlpbnQJCQlsbyA9IDA7
CisJaW50CQkJaGkgPSBzaXplb2Yoc3Fsc3RhdGVfbmFtZV90YWJsZSkgLyBzaXplb2Yoc3Fsc3Rh
dGVfbmFtZV90YWJsZVswXSkgLSAxOworCisJd2hpbGUgKGxvIDw9IGhpKQorCXsKKwkJaW50CQkJ
bWlkID0gKGxvICsgaGkpIC8gMjsKKwkJaW50CQkJY21wID0gc3RybmNtcChzcWxzdGF0ZSwgc3Fs
c3RhdGVfbmFtZV90YWJsZVttaWRdLnNxbHN0YXRlLCA1KTsKKworCQlpZiAoY21wIDwgMCkKKwkJ
CWhpID0gbWlkIC0gMTsKKwkJZWxzZSBpZiAoY21wID4gMCkKKwkJCWxvID0gbWlkICsgMTsKKwkJ
ZWxzZQorCQkJcmV0dXJuIHNxbHN0YXRlX25hbWVfdGFibGVbbWlkXS5zeW1ib2xpY19uYW1lOwor
CX0KKwlyZXR1cm4gTlVMTDsKK30KKworI2VuZGlmCQkJCQkJCS8qIFNRTFNUQVRFX05BTUVTX0gg
Ki8KK0ZPT1RFUgorCitjbG9zZSAkb3V0ZmggaWYgKCRvdXRmaWxlKTsKZGlmZiAtLWdpdCBhL3Ny
Yy9pbnRlcmZhY2VzL2xpYnBxL01ha2VmaWxlIGIvc3JjL2ludGVyZmFjZXMvbGlicHEvTWFrZWZp
bGUKaW5kZXggMDk2Mzk5NWVlZDQuLmFmMDZkNjczM2U2IDEwMDY0NAotLS0gYS9zcmMvaW50ZXJm
YWNlcy9saWJwcS9NYWtlZmlsZQorKysgYi9zcmMvaW50ZXJmYWNlcy9saWJwcS9NYWtlZmlsZQpA
QCAtMTQ2LDYgKzE0NiwxMiBAQCBlbmRpZgogZmUtY29ubmVjdC5vOiBmZS1jb25uZWN0LmMgJCh0
b3BfYnVpbGRkaXIpL3NyYy9wb3J0L3BnX2NvbmZpZ19wYXRocy5oCiBmZS1taXNjLm86IGZlLW1p
c2MuYyAkKHRvcF9idWlsZGRpcikvc3JjL3BvcnQvcGdfY29uZmlnX3BhdGhzLmgKIAorIyBnZW5l
cmF0ZSBzcWxzdGF0ZV9uYW1lcy5oIGZyb20gc3JjL2JhY2tlbmQvdXRpbHMvZXJyY29kZXMudHh0
CitzcWxzdGF0ZV9uYW1lcy5oOiAkKHRvcF9zcmNkaXIpL3NyYy9iYWNrZW5kL3V0aWxzL2VycmNv
ZGVzLnR4dCAkKHRvcF9zcmNkaXIpL3NyYy9iYWNrZW5kL3V0aWxzL2dlbmVyYXRlLXNxbHN0YXRl
LW5hbWVzLnBsCisJJChQRVJMKSAkKHRvcF9zcmNkaXIpL3NyYy9iYWNrZW5kL3V0aWxzL2dlbmVy
YXRlLXNxbHN0YXRlLW5hbWVzLnBsIC0tb3V0ZmlsZSAkQCAkPAorCitmZS1wcm90b2NvbDMubzog
ZmUtcHJvdG9jb2wzLmMgc3Fsc3RhdGVfbmFtZXMuaAorCiAkKHRvcF9idWlsZGRpcikvc3JjL3Bv
cnQvcGdfY29uZmlnX3BhdGhzLmg6CiAJJChNQUtFKSAtQyAkKHRvcF9idWlsZGRpcikvc3JjL3Bv
cnQgcGdfY29uZmlnX3BhdGhzLmgKIApAQCAtMTg4LDUgKzE5NCw2IEBAIGNsZWFuIGRpc3RjbGVh
bjogY2xlYW4tbGliCiAJJChNQUtFKSAtQyB0ZXN0ICRACiAJcm0gLXJmIHRtcF9jaGVjawogCXJt
IC1mICQoT0JKUykgJChPQkpTX1NITElCKSAkKE9CSlNfU1RBVElDKSBwdGhyZWFkLmggbGlicHEt
cmVmcy1zdGFtcAorCXJtIC1mIHNxbHN0YXRlX25hbWVzLmgKICMgTWlnaHQgYmUgbGVmdCBvdmVy
IGZyb20gYSBXaW4zMiBjbGllbnQtb25seSBidWlsZAogCXJtIC1mIHBnX2NvbmZpZ19wYXRocy5o
CmRpZmYgLS1naXQgYS9zcmMvaW50ZXJmYWNlcy9saWJwcS9mZS1wcm90b2NvbDMuYyBiL3NyYy9p
bnRlcmZhY2VzL2xpYnBxL2ZlLXByb3RvY29sMy5jCmluZGV4IDhjMWZkYTVjYWYwLi4wNGEzYzlh
OWVjZSAxMDA2NDQKLS0tIGEvc3JjL2ludGVyZmFjZXMvbGlicHEvZmUtcHJvdG9jb2wzLmMKKysr
IGIvc3JjL2ludGVyZmFjZXMvbGlicHEvZmUtcHJvdG9jb2wzLmMKQEAgLTI4LDYgKzI4LDcgQEAK
ICNpbmNsdWRlICJjb21tb24vaW50LmgiCiAjaW5jbHVkZSAibGlicHEtZmUuaCIKICNpbmNsdWRl
ICJsaWJwcS1pbnQuaCIKKyNpbmNsdWRlICJzcWxzdGF0ZV9uYW1lcy5oIgogI2luY2x1ZGUgIm1i
L3BnX3djaGFyLmgiCiAjaW5jbHVkZSAicG9ydC9wZ19ic3dhcC5oIgogCkBAIC0xMDgwLDcgKzEw
ODEsMTQgQEAgcHFCdWlsZEVycm9yTWVzc2FnZTMoUFFFeHBCdWZmZXIgbXNnLCBjb25zdCBQR3Jl
c3VsdCAqcmVzLAogCXsKIAkJdmFsID0gUFFyZXN1bHRFcnJvckZpZWxkKHJlcywgUEdfRElBR19T
UUxTVEFURSk7CiAJCWlmICh2YWwpCi0JCQlhcHBlbmRQUUV4cEJ1ZmZlcihtc2csICIlczogIiwg
dmFsKTsKKwkJeworCQkJY29uc3QgY2hhciAqc3ltYm9saWMgPSBzcWxzdGF0ZV90b19zeW1ib2xp
Y19uYW1lKHZhbCk7CisKKwkJCWlmIChzeW1ib2xpYykKKwkJCQlhcHBlbmRQUUV4cEJ1ZmZlciht
c2csICIlcyAoJXMpOiAiLCB2YWwsIHN5bWJvbGljKTsKKwkJCWVsc2UKKwkJCQlhcHBlbmRQUUV4
cEJ1ZmZlcihtc2csICIlczogIiwgdmFsKTsKKwkJfQogCX0KIAl2YWwgPSBQUXJlc3VsdEVycm9y
RmllbGQocmVzLCBQR19ESUFHX01FU1NBR0VfUFJJTUFSWSk7CiAJaWYgKHZhbCkKZGlmZiAtLWdp
dCBhL3NyYy9pbnRlcmZhY2VzL2xpYnBxL21lc29uLmJ1aWxkIGIvc3JjL2ludGVyZmFjZXMvbGli
cHEvbWVzb24uYnVpbGQKaW5kZXggYjBhZTcyMTY3YTEuLmQ4NDdkNWM0NDE0IDEwMDY0NAotLS0g
YS9zcmMvaW50ZXJmYWNlcy9saWJwcS9tZXNvbi5idWlsZAorKysgYi9zcmMvaW50ZXJmYWNlcy9s
aWJwcS9tZXNvbi5idWlsZApAQCAtNDIsNiArNDIsMTUgQEAgZXhwb3J0X2ZpbGUgPSBjdXN0b21f
dGFyZ2V0KCdsaWJwcS5leHBvcnRzJywKICAga3dhcmdzOiBnZW5fZXhwb3J0X2t3YXJncywKICkK
IAorZ2VuX3NxbHN0YXRlX25hbWVzID0gZmlsZXMoJy4uLy4uL2JhY2tlbmQvdXRpbHMvZ2VuZXJh
dGUtc3Fsc3RhdGUtbmFtZXMucGwnKQorc3Fsc3RhdGVfbmFtZXNfaCA9IGN1c3RvbV90YXJnZXQo
J3NxbHN0YXRlX25hbWVzJywKKyAgaW5wdXQ6IFsnLi4vLi4vYmFja2VuZC91dGlscy9lcnJjb2Rl
cy50eHQnXSwKKyAgb3V0cHV0OiBbJ3NxbHN0YXRlX25hbWVzLmgnXSwKKyAgY29tbWFuZDogW3Bl
cmwsIGdlbl9zcWxzdGF0ZV9uYW1lcywgJy0tb3V0ZmlsZScsICdAT1VUUFVUQCcsICdASU5QVVQw
QCddLAorKQorZ2VuZXJhdGVkX3NvdXJjZXMgKz0gc3Fsc3RhdGVfbmFtZXNfaAorbGlicHFfc291
cmNlcyArPSBzcWxzdGF0ZV9uYW1lc19oCisKICMgcG9ydCBuZWVkcyB0byBiZSBpbiBpbmNsdWRl
IHBhdGggZHVlIHRvIHB0aHJlYWQtd2luMzIuaAogbGlicHFfaW5jID0gaW5jbHVkZV9kaXJlY3Rv
cmllcygnLicsICcuLi8uLi9wb3J0JykKIGxpYnBxX2NfYXJncyA9IFsnLURTT19NQUpPUl9WRVJT
SU9OPTUnXQo=
--0000000000007a2e79064e6648a7--