| 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: | 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:
------------------------------------------------
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)
| 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 |