"G. Anthony Reina" <reina@nsi.edu> writes:
> Tom Lane wrote:
>> 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.
> Okay, so then you are saying that even though the DROP TABLE and ALTER
> TABLE RENAME went through correctly, the line after that bombed out,
> tried to rollback the transaction, and gave me the error?
Right. The system catalogs roll back just fine, but the Unix filesystem
doesn't know from rollbacks.
> I definitely missed that warning. Are there any big warnings for things
> that don't work so well within a transaction (BEGIN WORK; COMMIT WORK)?
ALTER TABLE RENAME is another one...
This is all fixed in 7.1 btw.
regards, tom lane