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

From Andres Freund
Subject Re: Read-only access to temp tables for 2PC transactions
Date
Msg-id 20190523155459.ksxmod6t42mihsgl@alap3.anarazel.de
Whole thread Raw
In response to Re: Read-only access to temp tables for 2PC transactions  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Read-only access to temp tables for 2PC transactions  (Michael Paquier <michael@paquier.xyz>)
Re: Read-only access to temp tables for 2PC transactions  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
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.

There's no way we can forbid using session after 2PC unconditionally,
it'd break most users of 2PC.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Pantelis Theodosiou
Date:
Subject: Re: PostgreSQL 12 Beta 1 press release draft
Next
From: Peter Geoghegan
Date:
Subject: Re: crash testing suggestions for 12 beta 1