SELECT datname FROM pg_database WHERE oid = 16388;
SELECT relname, CASE WHEN relkind = 'r' THEN 'TABLE' WHEN relkind = 'i' THEN 'INDEX' WHEN relkind = 'S' THEN 'SEQUENCE' WHEN relkind = 'v' THEN 'VIEW' WHEN relkind = 'c' THEN 'VIEW' WHEN relkind = 'f' THEN 'Foreign Table' ELSE 'Unknown' END FROM pg_class WHERE relfilenode = 35954;
Make sure you have a good backup then: 2. DROP the bad object. 3. RESTORE the object.
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.