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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
