"G. Anthony Reina" <reina(at)nsi(dot)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