database corruption help

Hi, my wal archiving broke and postgresql filled up the local disk with transaction logs, which i foolishly deleted in a moment of madness, after resetting the transaction log a few of my tables are damaged but repairable. However the system tables also seemed to have suffered. My main problem is duplicate rows which violated the primary key and if i do a reindex system i get similar errors, for example:

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 )

Many thanks
--

Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/