Re: [proposal] Add an option for returning SQLSTATE in psql error message

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: did447@gmail.com, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-12-03T16:12:26Z
Lists: pgsql-hackers
po 3. 12. 2018 v 16:49 odesílatel Andrew Gierth <andrew@tao11.riddles.org.uk>
napsal:

> >>>>> "didier" == didier  <did447@gmail.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)
>

It is good idea to look to this option.

Pavel


> --
> Andrew (irc:RhodiumToad)
>
>

Commits

  1. Add a "SQLSTATE-only" error verbosity option to libpq and psql.