"John Lister" <john.lister-ps@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
duplicatedand 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