Re: Possible bug in 7.4.5 - Mailing list pgsql-bugs

Devrim GUNDUZ <devrim@gunduz.org> writes:
> Am I missing something, or is it a bug? I can't reproduce it in 8.0beta2.

8.0 actually behaves the same way: the COMMIT gets you out of the
transaction block.  It just tells you that it's treating it as a
rollback:

regression=# comm;
ERROR:  syntax error at or near "comm" at character 1
LINE 1: comm;
        ^
regression=# commit;
ROLLBACK
regression=#

whereas prior versions did the rollback but still reported the command
tag as COMMIT.  AFAIR, Postgres has always acted that way.

            regards, tom lane