Re: error code with psql

Tatsuo Ishii wrote:
> Hi,
>
> Does anybody know how I can get error codes using psql? I know that I
> could get error codes from server log or using libpq function. I just
> could not figure out a way to display them in psql.

Sure. With psql, you need to set the VERBOSITY setting for psql to
access those error codes:

test=> CREATE TABLE test (x int UNIQUE);
NOTICE: CREATE TABLE / UNIQUE will create implicit index "test_x_key"
for table "test"
CREATE TABLE

test=> INSERT INTO test VALUES (1);
INSERT 17225 1
test=> INSERT INTO test VALUES (1);
ERROR: duplicate key violates unique constraint "test_x_key"

test=> \set VERBOSITY 'verbose'
test=> INSERT INTO test VALUES (1);
--> ERROR: 23505: duplicate key violates unique constraint "test_x_key"
LOCATION: _bt_check_unique, nbtinsert.c:255

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073