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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +