============================================================================
                        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'


Fri, 17 Apr 1998 14:29:37 +0000 (UTC)
"Jose' Soares Da Silva" <sferac@proxy.bazzanese.com>
drop table inside transactions