Re: [PATCH] Fix alter subscription concurrency errors - Mailing list pgsql-hackers

From Jelte Fennema
Subject Re: [PATCH] Fix alter subscription concurrency errors
Date
Msg-id HE1PR8303MB0075B62308DEDDD77D8B3D99F7759@HE1PR8303MB0075.EURPRD83.prod.outlook.com
Whole thread Raw
In response to Re: [PATCH] Fix alter subscription concurrency errors  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [PATCH] Fix alter subscription concurrency errors
Re: [PATCH] Fix alter subscription concurrency errors
List pgsql-hackers
> Won't the same thing can happen for similar publication commands? Why
> is this unique to the subscription and not other Alter/Drop commands?

I indeed don't think this problem is unique to subscriptions, but it seems
better to at least have this problem in a few places less (not making perfect
the enemy of good).

If someone has a more generic way of solving this for other commands too,
then that sounds great, but if not then slowly chipping away at these cases
seems better than keeping the status quo.

Attached is a new patch where ALTER SUBSCRIPTION ... OWNER TO ... can
now also be executed concurrently with the other subscription commands.
Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: pg_rewind WAL segments deletion pitfall
Next
From: Etsuro Fujita
Date:
Subject: Re: Asynchronous execution support for Custom Scan