"John Lister" <john.lister...@kickstone.com> writes:
> ERROR: could not create unique index "pg_class_oid_index"
> a quick inspection of the pg_class table doesn't show any duplicates, is
> there anyway i can find out which row(s) are duplicated and remove them
> without a full db restore?
> also doing something like this doesn't return anything which worked for my
> other tables
> select oid from pg_class where oid in(select oid from pg_class group by oid
> having count(oid)>1 )
Try doing it with enable_indexscan = off and enable_bitmapscan = off.
The system might be relying on the old, bogus index to do the group by
oid.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
