Horton

Re: [PATCH] psql: Display SQLSTATE macro name in verbose error reports

jian he <jian.universality@gmail.com>

View thread
From: jian he <jian.universality@gmail.com>
To: Aaryan Parik <aaryanparik124@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2026-05-24T01:56:55Z
Lists: pgsql-hackers 
On Sun, May 24, 2026 at 3:18 AM Aaryan Parik <aaryanparik124@gmail.com> wrote:
>
> Example output:
> ERROR:  42601: syntax error at or near "FRO"
> LINE 1: SELECT * FRO;
>                  ^
> LOCATION:  scanner_yyerror, scan.l:1220
> SQLSTATE name: ERRCODE_SYNTAX_ERROR
>
> I believe this will be a handy quality-of-life improvement for developers. Looking forward to any feedback
>

This seems identical to the patch submitted in the previous email thread, [0].

[0]: https://www.postgresql.org/message-id/CAK3UJRGc2RKfQMjwVDAwsuOJuobq3d4%2BQf9KWK1NHmK1vaqyxQ%40mail.gmail.com