Re: Read-only access to temp tables for 2PC transactions - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Read-only access to temp tables for 2PC transactions
Date
Msg-id CANP8+jJiSqRL5D+EAGGtkptj4rg-JB9+mKkr6VVhYrH7CB7XWA@mail.gmail.com
Whole thread Raw
In response to Re: Read-only access to temp tables for 2PC transactions  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Thu, 23 May 2019 at 16:55, Andres Freund <andres@anarazel.de> wrote:
Hi,

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

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Why does not subquery pruning conditions inherit to parent query?
Next
From: Simon Riggs
Date:
Subject: Re: Read-only access to temp tables for 2PC transactions