Re: [HACKERS] Drop table abort

> It seem that a drop table while in a transaction keeps the table but not the
> data. Bug? or undocumented feature?
>
> testcase=> select * from t;
> i
> -
> (0 rows)
>
> testcase=> insert into t VALUES(1);
> INSERT 551854 1
> testcase=> insert into t VALUES(2);
> INSERT 551855 1
> testcase=> insert into t VALUES(3);
> INSERT 551856 1
> testcase=> select * from t;
> i
> -
> 1
> 2
> 3
> (3 rows)
>
> testcase=> begin;
> BEGIN
> testcase=> insert into t VALUES(4);
> INSERT 551857 1
> testcase=> drop table t;
> DROP
> testcase=> abort;
> ABORT
> testcase=> select * from t;
> i
> -
> (0 rows)
>
> testcase=> select version();
> version

Known bug.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026