Re: Parser abort ignoring following commands

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>> Sure, because the transaction is rolled back. The whole string
>> is executed in one transaction. You will definitely break existing
>> applications if you change that.

> Applications that rely on this behaviour are broken. It was always said
> that statements are in their own transaction block unless in an explicit
> BEGIN/COMMIT block. A statement is defined to end at the semicolon, not
> at the end of the string you submit to PQexec().

Au contraire: single query strings have always been executed as single
transactions. Whether that would be the most consistent behavior in a
green field is quite irrelevant. We *cannot* change it now, or we will
break existing applications --- silently.

If you can find something in the documentation that states what you
claim is the definition, I'll gladly change it ;-).

regards, tom lane