RE: [HACKERS] drop table inside transactions

I wonder why it sometimes restores the data. Maybe because it's still in
the same area of the disk/file?

Michael
--
Dr. Michael Meskes, Projekt-Manager | topystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux! | Tel: (+49) 2405/4670-44

> ----------
> From: Jose' Soares Da Silva[SMTP:sferac(at)proxy(dot)bazzanese(dot)com]
> Sent: Freitag, 17. April 1998 19:05
> To: Meskes, Michael
> Cc: pgsql-hackers(at)postgreSQL(dot)org; pgsq-bugs(at)postgreSQL(dot)org;
> sferac(at)bo(dot)nettuno(dot)it
> Subject: RE: [HACKERS] drop table inside transactions
>
> 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.
> ;-)
>