Re: logical decoding of two-phase transactions - Mailing list pgsql-hackers

From Andres Freund
Subject Re: logical decoding of two-phase transactions
Date
Msg-id 20170327212528.cwf4aotytwrsowwx@alap3.anarazel.de
Whole thread Raw
In response to Re: logical decoding of two-phase transactions  (Stas Kelvich <s.kelvich@postgrespro.ru>)
Responses Re: logical decoding of two-phase transactions  (Craig Ringer <craig@2ndquadrant.com>)
Re: logical decoding of two-phase transactions  (Stas Kelvich <s.kelvich@postgrespro.ru>)
List pgsql-hackers
Hi,

On 2017-03-28 00:19:29 +0300, Stas Kelvich wrote:
> Ok, here it is.

On a very quick skim, this doesn't seem to solve the issues around
deadlocks of prepared transactions vs. catalog tables.  What if the
prepared transaction contains something like LOCK pg_class; (there's a
lot more realistic examples)? Then decoding won't be able to continue,
until that transaction is committed / aborted?

- Andres



pgsql-hackers by date:

Previous
From: Stas Kelvich
Date:
Subject: Re: logical decoding of two-phase transactions
Next
From: Fabien COELHO
Date:
Subject: Re: \if, \elseif, \else, \endif (was Re: PSQL commands:\quit_if, \quit_unless)