Re: [BUGS] postgresql-6.1.1: wrong roll-back'ing "drop table" query.

Drop table is not a transaction-able operation. This is expected
behavior.

[ic@cms PGconi]$ createdb bugexample
[ic@cms PGconi]$ psql bugexample
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: bugexample

bugexample=> create table foobar ( x int );
CREATE
bugexample=> insert into foobar values (1);
INSERT 3035918
bugexample=> insert into foobar values (2);
INSERT 3035919
bugexample=> \d

Database    = bugexample
+------------------+----------------------------------+----------+
|  Owner           |             Relation             |   Type   |
+------------------+----------------------------------+----------+
| ic               | foobar                           | table    |
+------------------+----------------------------------+----------+
bugexample=> select * from foobar;
x
-
1
2
(2 rows)

bugexample=> begin;
BEGIN
bugexample=> drop table foobar;
DROP
bugexample=> abort;
ABORT
bugexample=> select * from foobar;
x
-
(0 rows)

bugexample=>

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

?

ic

P.S. Sorry for my bad english grammatic ... :-(

--
Bruce Momjian
maillist@candle.pha.pa.us