Re: [HACKERS] ERROR: cannot open relation center_out_analog_proc

2001-03-06 Thread Tom Lane
"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

Re: [HACKERS] ERROR: cannot open relation center_out_analog_proc

2001-03-06 Thread G. Anthony Reina
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

Re: [HACKERS] ERROR: cannot open relation center_out_analog_proc

2001-03-06 Thread Tom Lane
"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