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 по дате отправления:

Предыдущее
От: "Jose' Soares Da Silva"
Дата:
Сообщение: escape character \
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: [HACKERS] Re: [PATCHES] ecpg patch