Drop table abort

Jackson, DeJuan <djackson@cpsgroup.com>

From: "Jackson, DeJuan" <djackson@cpsgroup.com>
To: PGSQL Hackers <pgsql-hackers@hub.org>
Date: 1999-08-09T20:15:20Z
Lists: pgsql-hackers
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                                                       
--------------------------------------------------------------
PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3