pgsql: Use weaker locks when updating pg_subscription_rel

Started by Peter Eisentrautover 9 years ago1 messagescomitters

peter_e@gmx.net

over 9 years ago

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: /messages/by-id/13592.1490851519@sss.pgh.pa.us

Author: Petr Jelinek <petr.jelinek@2ndquadrant.com>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/521fd4795e3ec3d0b263b62e5eb58e1557be9c86

Modified Files
--------------
src/backend/catalog/pg_subscription.c | 12 +++++++-----
1 file changed, 7 insertions(+), 5 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers