Andres Freund <and...@anarazel.de> writes: > On Tuesday 02 November 2010 22:59:15 Kevin Grittner wrote: >>> Does anybody have any idea why COMMIT is allowed there? Seems >>> pretty strange to me.
>> So that the "failed transaction" state can be cleared. The >> transaction as a whole has failed, but you don't want the connection >> to become useless. > Well, allowing ROLLBACK is enought there, isnt it? The client has no reason to think the transaction has failed, so what it's going to send is COMMIT, not ROLLBACK. From the point of view of the client, this should look like its COMMIT failed (or in general its next command failed); not like there was some magic action-at-a-distance on the state of its transaction. Now you could argue that if you send COMMIT, and that fails, you should have to send ROLLBACK to get to an idle state ... but that's not how this ever worked before, and I don't think it's what the SQL standard expects either. After a COMMIT, you're out of the transaction either way. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers