I'm guessing I'm gonna have to route through pg_catalog for this and delete all deps manually, but it this going to be safe? Would I be better off dumping and restoring the whole database?
Right then, I think I've got this sorted, DROP TABLE worked after a swift:
DELETE FROM pg_depend WHERE objid = 5173132;
Then DROP SCHEMA also worked.
Do you think I should be safe to continue working with the database now, without a full dump and restore? (It's not in production use, but it would take quite some time for dump/restore)
Cheers. -- Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk> Web Developer & Database Admin Cromwell Tools Ltd. Leicester, England.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
