drop table inside transactions
От | Jose' Soares Da Silva |
---|---|
Тема | drop table inside transactions |
Дата | |
Msg-id | Pine.LNX.3.96.980417142825.1185B-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: ------------------------------------------------ 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'
В списке pgsql-hackers по дате отправления: