Re: [HACKERS] DROP TABLE inside a transaction block - Mailing list 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