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);
> test=# 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?
> test=# end;
> test=# \d
> No relations found.
> Tatsuo Ishii
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
In response to
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2000-03-05 13:39:37|
|Subject: Re: [HACKERS] TransactionStateData and AbsoluteTime|
|Previous:||From: Peter Eisentraut||Date: 2000-03-05 13:29:50|
|Subject: pg_pwd trigger to be removed|