"John Lister" <john.lister-ps@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
