On Wed, Jun 24, 2026 at 7:49 PM vignesh C <vignesh21@gmail.com> wrote:
> Thanks for the patch. I verified that it fixes the issue with reading
> unlogged sequences on a promoted standby.
Thanks for testing!
> Do you think it would be worthwhile to add a test for this scenario,
> or do you feel the additional test is not necessary in this case?
I think it's worth adding a test for this scenario, so I've added one to
the patch. The test uses nextval() to read the unlogged sequence
instead of pg_get_sequence_data(), since this patch needs to be
backpatched to v15, while pg_get_sequence_data() was introduced in
v19.
Attached are updated patches for master and the stable branches.
Regards,
--
Fujii Masao
