DROP TABLE inside transactions

From: "Jose' Soares Da Silva" <sferac(at)proxy(dot)bazzanese(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: DROP TABLE inside transactions
Date: 1998-04-16 13:18:43
Message-ID: Pine.LNX.3.96.980416131650.399A-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:
------------------------------------------------

I found a lock error on transactions using drop table.
Take a look...

--first user:------------------------------------------------------
BEGIN WORK;
prova=> SELECT * FROM tmp;
a
-----
first
last
(2 rows)

prova=> DROP TABLE tmp;
DROP
prova=> SELECT * FROM tmp;
ERROR: tmp: Table does not exist.

--second user:---------------------------------------------------

prova=> select * from tmp;
a
-
(0 rows)

prova=> insert into tmp values ('new');
INSERT 178789 1
prova=> select * from tmp;
a
-----
first
last
new
(3 rows)

--again first user:--------------------------------------------------

prova=> select * from tmp;
ERROR: tmp: Table does not exist.
prova=> commit;
END
prova=> select * from tmp;
a
-----
first
last
new
(3 rows)

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-04-16 13:19:24 Re: [HACKERS] Division by Zero
Previous Message Marc Howard Zuckman 1998-04-16 13:01:11 Re: [HACKERS] HAVING clause and 6.3.2 release