| 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: | Whole Thread | Raw Message | 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'
| 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 |