On Fri, Jun 14, 2013 at 10:54 AM, Joshua D. Drake <j...@commandprompt.com> wrote: > Now, with the error previously shown, which one_idx needs to be reindexed?
Well, you didn't show an actual error message. But if you "\set VERBOSITY verbose" within psql while connected to a 9.3 server, you'll get fully qualified details of the constraint blamed for the error, if any. Example: postgres=# insert into a(a, b) values (3, 'test'); ERROR: 23505: duplicate key value violates unique constraint "a_pkey" DETAIL: Key (a)=(3) already exists. SCHEMA NAME: public TABLE NAME: a CONSTRAINT NAME: a_pkey LOCATION: _bt_check_unique, nbtinsert.c:398 -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
