On 2019-05-23 12:36:09 +0100, Simon Riggs wrote: > The ONLY case where this matters is if someone does a PREPARE and then > starts doing other work on the session. Which makes no sense in the normal > workflow of a session. I'm sure there are tests that do that, but those > tests are unrepresentative of sensible usage.
That's extremely common.
Not at all.
There's no way we can forbid using session after 2PC unconditionally, it'd break most users of 2PC.
Since we disagree, can you provide more information about this usage pattern?
--
Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services