Cheers tom, that did it - i've removed the duplicates and seeing what else
is broken.
.
"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
