Re: locking [user] catalog tables vs 2pc vs logical rep

vignesh C <vignesh21@gmail.com>

From: vignesh C <vignesh21@gmail.com>

To: Ajin Cherian <itsajin@gmail.com>

Cc: Andres Freund <andres@anarazel.de>, Pg Hackers <pgsql-hackers@postgresql.org>, Amit Kapila <amit.kapila16@gmail.com>, Markus Wanner <markus.wanner@enterprisedb.com>

Date: 2021-03-31T12:17:50Z

Lists: pgsql-hackers

Attachments

v2-0001-Fail-prepared-transaction-if-transaction-has-lock.patch (text/x-patch) patch v2-0001

On Wed, Mar 31, 2021 at 2:35 PM Ajin Cherian <itsajin@gmail.com> wrote:
>
> The patch applies fine on HEAD and "make check" passes fine. No major comments on the patch, just a minor comment:
>
> If you could change the error from, " cannot PREPARE a transaction that has a lock on user catalog/system table(s)"
> to "cannot PREPARE a transaction that has an exclusive lock on user catalog/system table(s)" that would be a more
> accurate instruction to the user.
>

Thanks for reviewing the patch.
Please find the updated patch which includes the fix for the same.

Regards,
Vignesh

Commits

Doc: Update caveats in synchronous logical replication.
- 4be39ef9cbc5 9.6.23 landed
- f365151a5392 10.18 landed
- e00e5db22d79 11.13 landed
- a73bd49c69e1 12.8 landed
- 7a4ecefe9d77 13.4 landed
- c66fb78ebb4f 14.0 landed
Document a few caveats in synchronous logical replication.
- acdb523cb642 9.6.23 landed
- ff33be61f212 10.18 landed
- 5a456034b84e 11.13 landed
- 9f7bba2629cf 13.4 landed
- eb231dbd80d2 12.8 landed
- 3cb828dbe260 14.0 landed
Update the docs and comments for decoding of prepared xacts.
- b4e3dc7fd420 14.0 landed
Allow decoding at prepare time in ReorderBuffer.
- a271a1b50e9b 14.0 cited
Documentation for logical decoding.
- 49c0864d7ef5 9.4.0 cited