Re: Logical Replication of sequences - Mailing list pgsql-hackers

On Wed, Nov 5, 2025 at 5:28 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> I have pushed the 0001 after making minor adjustments in tests and at
> a few other places. Kindly rebase and send the remaining patches.

I discovered that the sequence sync worker fails for sequences
containing single quotes.
---
2025-11-06 10:22:50.335 JST [1096008] ERROR:  could not fetch sequence
information from the publisher: ERROR:  syntax error at or near
"quote"
        LINE 4: FROM ( VALUES ('public', 'regress'quote', 0), ('public', 'ho...
                                                  ^
2025-11-06 10:22:50.335 JST [1088168] LOG:  background worker "logical
replication sequencesync worker" (PID 1096008) exited with exit code 1
---

I haven't read all the threads, so I might be mistaken, but I've
created a patch.


--
Best regards,
Shinya Kato
NTT OSS Center