| 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 16:21:38 |
| Message-ID: | CAJRYxu+X637Tdn+hkZe81dr0oaCxksw7z-ewn4uUL2ANOdr7Rw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Yep, name is bad, but I'm not sure about VERBOSITY, isn't it
controlling output from the server not the client?
You may want to set both VERBOSITY to 'verbose' and ECHO_ERROR to
'none' then in script do
SELECT .... -- no error output
\if :ERROR
-- do something with LAST_ERROR_MESSAGE
On Mon, Dec 3, 2018 at 4:49 PM Andrew Gierth
<andrew(at)tao11(dot)riddles(dot)org(dot)uk> wrote:
>
> >>>>> "didier" == didier <did447(at)gmail(dot)com> writes:
>
> didier> Attached a POC adding a new variable ECHO_ERROR
> didier> \set ECHO_ERROR text|none|psqlstate
>
> I wouldn't have called it that. Possibly another option to the existing
> VERBOSITY variable? \set VERBOSITY sqlstate_only or something of that
> ilk (it's already not unusual to use \set VERBOSITY terse in regression
> tests)
>
> --
> Andrew (irc:RhodiumToad)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Liudmila Mantrova | 2018-12-03 16:23:09 | Re: SQL/JSON: documentation |
| Previous Message | Pavel Stehule | 2018-12-03 16:12:26 | Re: [proposal] Add an option for returning SQLSTATE in psql error message |