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.
> ;-)
> 

Sat, 18 Apr 1998 22:04:15 +0200
"Meskes, Michael" <meskes@topsystem.de>
RE: [HACKERS] drop table inside transactions