> -----Original Message-----
> From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
> Sent: Friday, September 03, 1999 12:22 AM
> To: Tom Lane
> Cc: Hiroshi Inoue; pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] md.c is feeling much better now, thank you
>
>
> > BTW, it appears that DROP TABLE physically deletes the relation
> > *immediately*, which means that aborting a transaction that contains
> > a DROP TABLE does not work. But we knew that, didn't we?
>
> Yes, on TODO.
>
Hmm,Data Define commands are unrecoverable in many DBMS-s.
Is it necessary to allow PostgreSQL to execute Data Define
commands inside transactions ?
If so,is it possible ?
For example,should the following be possible ?
[A table t exists.]
begin;
drop table t;
create table t (dt int4);
insert into t values (1);
drop table t;
abort;
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp