Horton
Menu

Re: Error on failed COMMIT

Vladimir Sitnikov <sitnikov.vladimir@gmail.com>

View thread
From: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Dave Cramer <davecramer@postgres.rocks>, Robert Haas <robertmhaas@gmail.com>, Shay Rojansky <roji@roji.org>, "Haumacher, Bernhard" <haui@haumacher.de>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-02-25T05:58:43Z
Lists: pgsql-hackers 
>do you think most common connection poolers would continue to
>work after making this change?

Of course, they should.
There are existing cases when commit responds with an error: deferrable
constraints.

There's nothing new except it is suggested to make the behavior of
commit/prepare failure (e.g. "can't commit the transaction because...")
consistent with other commit failures (e.g. deferred violation).

Vladimir