"G. Anthony Reina" <[EMAIL PROTECTED]> 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
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.
>
> The only way
"G. Anthony Reina" <[EMAIL PROTECTED]> 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 r
I was trying to add a column to a table and fill it but ran into a big
error. Apparently now Postgres can't open this table to vacuum or to
select although it does show up when I ask psql to describe the table
(i.e. db01=# /d center_out_analog_proc).
I'm using Postgres 7.0.3 on a PII/400 MHz with
