]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c45b1d2) | patch
Use weaker locks when updating pg_subscription_rel
authorPeter Eisentraut <peter_e@gmx.net>
Mon, 10 Apr 2017 19:08:14 +0000 (15:08 -0400)
committerPeter Eisentraut <peter_e@gmx.net>
Mon, 10 Apr 2017 19:08:14 +0000 (15:08 -0400)
commit521fd4795e3ec3d0b263b62e5eb58e1557be9c86
treebe08cb0716ac427b4037ea971365244438d22c70tree | snapshot
parentc45b1d2283c6631b990de25098ea389a1b96277acommit | diff
Use weaker locks when updating pg_subscription_rel

The previously used ShareRowExclusiveLock, while technically probably
more correct, led to deadlocks during seemingly unrelated operations and
thus a poor experience.  Use RowExclusiveLock, like for most similar
catalog operations.  In some care cases, the user might see an error
from DDL commands.

Discussion: https://www.postgresql.org/message-id/flat/13592.1490851519%40sss.pgh.pa.us

Author: Petr Jelinek <petr.jelinek@2ndquadrant.com>
src/backend/catalog/pg_subscription.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.