RE: sequencesync worker race with REFRESH SEQUENCES - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: sequencesync worker race with REFRESH SEQUENCES
Date
Msg-id OS9PR01MB12149488D158FF69F7D1F200FF5C12@OS9PR01MB12149.jpnprd01.prod.outlook.com
Whole thread
In response to Re: sequencesync worker race with REFRESH SEQUENCES  (vignesh C <vignesh21@gmail.com>)
List pgsql-hackers
Dear Vignesh,

> The attached patch has the changes for the same. This patch also fixes
> the issue reported by Kuroda-san at [1].

Thanks for updating the patch. I confirmed after applying your patch, the ALTER
SUBSCRIPTION could raise an ERROR like:

```
postgres=# ALTER SERVER server OPTIONS (SET port '5434');
ALTER SERVER
postgres=# ALTER SUBSCRIPTION sub REFRESH SEQUENCES ;
ERROR:  cannot synchronize sequences if the publisher is running a version earlier than PostgreSQL 19
```

... because the backend always confirms the remove version before updating the local catalog.
I have no comments anymore.

Best regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Fix missing FORMAT when deparsing JSON_ARRAY(query)
Next
From: Michael Paquier
Date:
Subject: Re: injection_points: canceled or terminated waiters leak their wait slots