Re: 8.0b4: COMMIT outside of a transaction echoes ROLLBACK

Ian Barwick wrote:
> just wondering:
> 
> test=> select version();
>                                          version
> ------------------------------------------------------------------------------------------
>  PostgreSQL 8.0.0beta4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
> 3.3.3 (SuSE Linux)
> (1 row)
> 
> test=> begin;
> BEGIN
> test=> commit;
> COMMIT
> test=> commit;
> WARNING:  there is no transaction in progress
> ROLLBACK
> 
> Is there any reason ROLLBACK and not COMMIT is echoed here?

Because the transaction was not committed, but rather rolled back.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073