RE: Re-read subscription state after lock in AlterSubscription - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: Re-read subscription state after lock in AlterSubscription
Date
Msg-id OS9PR01MB12149E944D7ECABF0C1DDCCB4F5F42@OS9PR01MB12149.jpnprd01.prod.outlook.com
Whole thread
List pgsql-hackers
Dear Bertrand,

> Yeah, but I think they would produce "tuple concurrently updated" error (due to
> CatalogTupleUpdate) so that invalid information could not be used.

I confirmed with PG14 that tuple concurrently updated ERROR can be raised when
ALTER SUBSCRIPTION DISABLE happens concurrently:

```
postgres=# ALTER SUBSCRIPTION sub DISABLE ;
ERROR:  tuple concurrently updated
```

It might be harmless but I think the correct ERROR should be reported: the patch
should be backpatched. Thought?

Best regards,
Hayato Kuroda
FUJITSU LIMITED




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: GetBufferDescriptor() being called for local buffers from MarkBufferDirtyHint()
Next
From: Japin Li
Date:
Subject: Re: Global temporary tables