From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | PGSQL Hackers <pgsql-hackers(at)hub(dot)org> |
Subject: | Drop table abort |
Date: | 1999-08-09 20:15:20 |
Message-ID: | D05EF808F2DFD211AE4A00105AA1B5D2431D6E@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-08-09 20:32:26 | Re: Pronunciation of "PostgreSQL" (was: Re: [HACKERS] New man pages) |
Previous Message | J. Michael Roberts | 1999-08-09 19:51:02 | Re: Pronunciation of "PostgreSQL" (was: Re: [HACKERS] New man pages) |