Devrim GUNDUZ <devrim(at)gunduz(dot)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