Re: Read-only access to temp tables for 2PC transactions

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Read-only access to temp tables for 2PC transactions
Дата
Msg-id 20190523155459.ksxmod6t42mihsgl@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Read-only access to temp tables for 2PC transactions  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Read-only access to temp tables for 2PC transactions
Re: Read-only access to temp tables for 2PC transactions
Список 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 по дате отправления:

Предыдущее
От: Pantelis Theodosiou
Дата:
Сообщение: Re: PostgreSQL 12 Beta 1 press release draft
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: crash testing suggestions for 12 beta 1