DROP TABLE inside transactions
От | Jose' Soares Da Silva |
---|---|
Тема | DROP TABLE inside transactions |
Дата | |
Msg-id | Pine.LNX.3.96.980416131650.399A-100000@proxy.bazzanese.com обсуждение исходный текст |
Список | pgsql-hackers |
============================================================================ 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: ------------------------------------------------ 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)
В списке pgsql-hackers по дате отправления: