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@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux!      | Tel: (+49) 2405/4670-44

> ----------
> From:     Jose' Soares Da Silva[SMTP:sferac@proxy.bazzanese.com]
> Sent:     Freitag, 17. April 1998 19:05
> To:     Meskes, Michael
> Cc:     pgsql-hackers@postgreSQL.org; pgsq-bugs@postgreSQL.org;
> sferac@bo.nettuno.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.
> ;-)
>