drop table inside transactions

From: "Jose' Soares Da Silva" <sferac(at)proxy(dot)bazzanese(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsq-bugs(at)postgresql(dot)org
Cc: sferac(at)bo(dot)nettuno(dot)it
Subject: drop table inside transactions
Date: 1998-04-17 14:29:37
Message-ID: Pine.LNX.3.96.980417142825.1185B-100000@proxy.bazzanese.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jose' Soares
Your email address : sferac(at)bo(dot)nettuno(dot)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'

Browse pgsql-hackers by date

  From Date Subject
Next Message Byron Nikolaidis 1998-04-17 14:40:34 Re: [HACKERS] Re: [INTERFACES] Re: ODBC driver
Previous Message Meskes, Michael 1998-04-17 12:45:00 RE: [HACKERS] drop table inside transactions