Horton

RE: [HACKERS] drop table inside transactions

Jose' Soares Da Silva <sferac@proxy.bazzanese.com>

View thread
From: "Jose' Soares Da Silva" <sferac@proxy.bazzanese.com>
To: "Meskes, Michael" <meskes@topsystem.de>
Cc: pgsql-hackers@postgreSQL.org, pgsq-bugs@postgreSQL.org, sferac@bo.nettuno.it
Date: 1998-04-17T17:05:08Z
Lists: pgsql-hackers 
On Fri, 17 Apr 1998, Meskes, Michael wrote:

> Is this really a bug? I haven't seen any (commercial) system supporting
> this kind of transaction recovery. Once you drop a table the data is
> lost, no matter if you rollback or not. 
> 
> Michael
Maybe you are right Michael, but there's another point; the table wasn't
removed, it is still there, only data are cancelled.
It's more, like a DELETE FROM ... not a DROP TABLE... 
and, if another user inserts data into this dropped table,
the table returns with all data.
(Refer to my first bug-report on this matter),
and more; some times ROLLBACK restores both data and table structure. ;-)
> 
> > prova=> drop table a;
> > DROP
> > prova=> select * from a;
> > ERROR:  a: Table does not exist.
> > prova=> rollback;
> > ABORT
> > prova=> select * from a;
> > a
> > -
> > (0 rows)
> >                                                          Jose'