Viewing new 9.3 error fields

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Viewing new 9.3 error fields
Дата
Msg-id 20130411180847.GE6028@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>)
Список pgsql-hackers
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/$
INSERTINTO 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
functioncopy_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  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Inconsistent DB data in Streaming Replication
Следующее
От: "Dickson S. Guedes"
Дата:
Сообщение: Re: Viewing new 9.3 error fields