On Fri, Jun 14, 2013 at 10:54 AM, Joshua D. Drake <jd@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