Horton

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

Andrew Gierth <andrew@tao11.riddles.org.uk>

View thread View on postgr.es
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: didier <did447@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-12-03T01:47:11Z
Lists: pgsql-hackers 
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.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)

Commits

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