DROP TABLE inside a transaction block

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: DROP TABLE inside a transaction block
Date: 2000-03-05 09:09:51
Message-ID: 20000305180951D.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
DROP
test=# end;
COMMIT
test=# \d
No relations found.
--
Tatsuo Ishii

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brian Hirt 2000-03-05 09:26:55 Optimizer badness in 7.0 beta
Previous Message Tatsuo Ishii 2000-03-05 01:54:56 TransactionStateData and AbsoluteTime