This is news?
> junk=# drop table aaa;
> NOTICE: Caution: DROP TABLE cannot be rolled back, so don't abort now
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> DROP
> junk=# rollback;
> ROLLBACK
What did you think the NOTICE was trying to tell you? (I wanted to
make it a hard ERROR, but was shot down.)
This will be fixed eventually, but until something is done to decouple
filenames from relation names it can't be fixed properly. Consider
BEGIN; DROP TABLE foo; CREATE TABLE foo ...; ABORT. There are plans
in the pipeline to do that, and we'll fix it when that happens.
regards, tom lane