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