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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
