Re: ERROR: cannot open relation center_out_analog_proc

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