Re: ERROR: cannot open relation center_out_analog_proc

"G. Anthony Reina" <reina@nsi.edu> writes:
> BEGIN WORK;
> ...
> DROP TABLE center_out_analog_proc;
> ...
> [fail transaction]

> psql:alter_table_format.sql:14: NOTICE:  mdopen: couldn't open
> center_out_analog_proc: No such file or directory

You can't roll back a DROP TABLE under pre-7.1 releases (and 7.0 has
a big fat warning notice to tell you so!).  The physical table file
is deleted immediately by the DROP, so rolling back the system catalog
changes doesn't get you back to a working table.

The only way to clean up at this point is to drop the table for real.
        regards, tom lane