Re: Viewing new 9.3 error fields

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 (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?
> 
> \set VERBOSITY verbose

Thanks, that worked.  :-)

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +