Viewing new 9.3 error fields
От
Bruce Momjian
Тема
Viewing new 9.3 error fields
Дата
Msg-id
20130411180847.GE6028@momjian.us
Список
Дерево обсуждения
Viewing new 9.3 error fields Bruce Momjian <bruce@momjian.us>
Re: Viewing new 9.3 error fields "Dickson S. Guedes" <listas@guedesoft.net>
Re: Viewing new 9.3 error fields Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Viewing new 9.3 error fields Bruce Momjian <bruce@momjian.us>
This blog entry displays the new 9.3 error fields, schema/table/constraint: http://www.depesz.com/2013/03/07/waiting-for-9-3-provide-database-object-names-as-separate-fields-in-error-messages/$ INSERT INTO t (i) VALUES (1);psql:z.sql:16: ERROR: 23505: duplicate key value violates unique constraint "t2_pkey"DETAIL: Key (i)=(1) already exists.CONTEXT: SQL statement "INSERT INTO t2 (i) VALUES (NEW.i)"PL/pgSQL function copy_value() line 4 at SQL statement --> SCHEMA NAME: public --> TABLE NAME: t2 --> CONSTRAINT NAME: t2_pkeyLOCATION: _bt_check_unique, nbtinsert.c:398 However, I am unable to see this in psql: CREATE TABLE ledger (id SERIAL, balance NUMERIC(10,2) unique);SET log_error_verbosity = 'verbose';INSERT INTO ledger VALUES (DEFAULT, 1);INSERT INTO ledger VALUES (DEFAULT, 1);ERROR: duplicate key value violates unique constraint "ledger_balance_key"DETAIL: Key (balance)=(1.00) already exists. --> What am I missing? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
В списке pgsql-hackers по дате отправления