From: | didier <did447(at)gmail(dot)com> |
---|---|
To: | andrew(at)tao11(dot)riddles(dot)org(dot)uk |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [proposal] Add an option for returning SQLSTATE in psql error message |
Date: | 2018-12-03 15:40:54 |
Message-ID: | CAJRYxuJqKv7SmcOcXGhYv6WGQEcBSU=DJvNx8SCt_nYv+sZaQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Attached a POC adding a new variable ECHO_ERROR
\set ECHO_ERROR text|none|psqlstate
On Mon, Dec 3, 2018 at 2:47 AM Andrew Gierth
<andrew(at)tao11(dot)riddles(dot)org(dot)uk> wrote:
>
> >>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
> Tom> I don't buy that argument. We use psql's normal display in all the
> Tom> regular regression tests, and it's not a big maintenance problem.
>
> The regular regression tests have the advantage that they don't need to
> work across pg versions.
>
> It is more of a problem for extensions; I just ran into this myself in
> fact, with a test failing because "invalid input syntax for integer" got
> changed to "invalid input syntax for type integer".
>
> --
> Andrew (irc:RhodiumToad)
Attachment | Content-Type | Size |
---|---|---|
master_psql_error_output.diff | text/x-patch | 4.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2018-12-03 15:49:39 | Re: Commitfest 2018-11 |
Previous Message | Charles Leifer | 2018-12-03 15:07:47 | JSON Merge-Patch |