Re: [HACKERS] DROP TABLE inside a transaction block
От | Peter Eisentraut |
---|---|
Тема | Re: [HACKERS] DROP TABLE inside a transaction block |
Дата | |
Msg-id | Pine.LNX.4.21.0003051434090.347-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | DROP TABLE inside a transaction block (Tatsuo Ishii <t-ishii@sra.co.jp>) |
Ответы |
Re: [HACKERS] DROP TABLE inside a transaction block
|
Список | pgsql-hackers |
Tatsuo Ishii writes: > I see following in HISTORY: > > Disallow DROP TABLE/DROP INDEX inside a transaction block > > However, it seems that this is not done with current? > > test=# create table t1(i int); > CREATE > test=# begin; > BEGIN > test=# drop table t1; > NOTICE: Caution: DROP TABLE cannot be rolled back, so don't abort now Wow, with all due respect, that's pretty sh^H^Hpoor. That's like saying "Haha, either you commit your transaction or your database is fried." Any reason that's not an ERROR before anything destructive is done? > DROP > test=# end; > COMMIT > test=# \d > No relations found. > -- > Tatsuo Ishii > > ************ > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-hackers по дате отправления: