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

On 2022-Aug-26, Jelte Fennema wrote:

> 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.

Would it work to use get_object_address() instead?  That would save
having to write a lookup-and-lock function with a retry loop for each
object type.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/