RE: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc. - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.
Date
Msg-id OS9PR01MB12149272CBB893D0089E03FC4F5D42@OS9PR01MB12149.jpnprd01.prod.outlook.com
Whole thread
In response to Re: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Dear Jeff,

> New v4 series attached.

Thanks for updating the patch. While seeing 0001, I found that GetSubscription()
and SubscriptionConninfo() are called without acquiring the lock for the
subscription. Is there a possibility that DDL commands are executed concurrently
and the cache can be invalidated in-between, thus it causes inconsistent results?
I tested concurrent ALTER SUBSCRIPTION SET OWNER command in maybe_reread_subscription(),
but the cache is not invalidated thus changing the owner is not reflected.
Is it OK?

Best regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: [PATCH] Fix vacuum_delay_point happening inside lock
Next
From: shveta malik
Date:
Subject: Re: Support EXCEPT for TABLES IN SCHEMA publications