On Sun, Nov 02, 2003 at 01:45:39PM -0500, Brian Ristuccia wrote: > > pg_dump: NOTICE: RelationBuildDesc: can't open deprecated_data1: No such file or > directory > pg_dump: NOTICE: RelationBuildDesc: can't open unimportant_stuff: No such file or > directory > pg_dump: handler procedure for procedural language plpgsql not found > > I can't drop the tables from psql: > > drop TABLE deprecated_data1 ; > ERROR: cannot open deprecated_data1: No such file or directory >
Ok. I managed to drop these in the standalone backend with some hackery: backend> drop table useless_junk NOTICE: RelationBuildDesc: can't open useless_junk: No such file or directory ERROR: cannot open useless_junk: No such file or directory So I'd have to go select on pg_class and find the relfilenode, go touch that file so it exists. Try the drop again. Drop any indexes which don't exist. Find the relfilenode for the associated pg_toast table and go touch that file too. Not a lot of fun, but the destroyed tables are gone now. > Am I likely to have success by performing surgery on the pg_table relation > in order to remove these destroyed tables? A simple DROP LANGUAGE did the trick. I can now run pg_dump - I feel much better. -- Brian Ristuccia ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
