RE: [HACKERS] drop table inside transactions

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

--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

> -----Original Message-----
> From:	Jose' Soares Da Silva [SMTP:sferac@proxy.bazzanese.com]
> Sent:	Friday, April 17, 1998 4:30 PM
> To:	pgsql-hackers@postgreSQL.org; pgsq-bugs@postgreSQL.org
> Cc:	sferac@bo.nettuno.it
> Subject:	[HACKERS] drop table inside transactions
> 
> ======================================================================
> ======
>                         POSTGRESQL BUG REPORT TEMPLATE
> ======================================================================
> ======
> 
> Your name		:	Jose' Soares
> Your email address	:	sferac@bo.nettuno.it 
> 
> 
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)  	: Intel Pentium
> 
>   Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.0.31
> Elf
> 
>   PostgreSQL version (example: PostgreSQL-6.1)  : PostgreSQL-snapshot
> april 6, 1998
> 
>   Compiler used (example:  gcc 2.7.2)		: gcc 2.7.2.1
> 
> 
> Please enter a FULL description of your problem:
> ------------------------------------------------
> 
> There's another bug on transactions. If one drop a table inside a
> transaction
> and then change his mind and rollback work, the table structure is
> restored
> but data are lost.
> Take a look...
> 
> prova=> begin work;
> BEGIN
> prova=> lock table a;
> DELETE 0
> prova=> select * from a;
>   a
> ---
>   1
>  13
> 134
> (3 rows)
> 
> 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'
>