Re: [HACKERS] Viewing new 9.3 error fields

2013-04-11 Thread Dickson S. Guedes
Em Qui, 2013-04-11 às 14:08 -0400, Bruce Momjian escreveu: 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)

Re: [HACKERS] Viewing new 9.3 error fields

2013-04-11 Thread Alvaro Herrera
Bruce Momjian wrote: 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);

Re: [HACKERS] Viewing new 9.3 error fields

2013-04-11 Thread Bruce Momjian
On Thu, Apr 11, 2013 at 03:31:17PM -0300, Alvaro Herrera wrote: Bruce Momjian wrote: 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