Synchronization of sequences to subscriber

Edit
ID 5111
Title Synchronization of sequences to subscriber
CI (CFBot) Summary
Stats (from CFBot) Patch version: v20250905, Patch count: 7, First patch: +48−11, All patches: +3327−935
Topic Replication & Recovery
Tags Logical Replication
Created 2024-07-05 12:00:21
Last modified 2025-08-01 06:54:36 (1 month ago)
Latest email 2025-09-05 11:20:06 (20 hours ago)
Status
PG19-2 (2025-09-01 – 2025-09-30): Needs review
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
Target version
Authors vigneshwaran C (vignesh.postgres)
Reviewers Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250)Become reviewer
Committer
Links
Emails
Logical Replication of sequences
First at 2024-06-04 10:57:03 by Amit Kapila <amit.kapila16 at gmail.com>
Latest at 2025-09-05 11:20:06 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v20250905-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-09-05 05:49:54 from vignesh C <vignesh21 at gmail.com>
    Attachment (v20250905-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-09-05 05:49:54 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250904-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-09-04 16:50:43 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250902-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-09-02 13:42:00 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250901-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-09-01 05:39:31 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (fetch_relation_list.diffs) at 2025-08-28 11:37:56 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v20250823-0004-Update-ALTER-SUBSCRIPTION-REFRESH-to-ALTER.patch) at 2025-08-21 16:38:42 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250818-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-08-18 10:06:45 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250813-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-08-13 10:56:58 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250806-0003-Reorganize-tablesync-Code-and-Introduce-sy.patch) at 2025-08-06 08:57:57 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250801-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-08-01 04:33:03 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250728-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-07-28 10:06:55 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250724-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-07-24 15:31:50 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250723-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-07-23 06:52:52 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250720-0001-Enhance-pg_get_sequence_data-function.patch) at 2025-07-20 14:15:13 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250717-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-07-17 11:21:53 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250716-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-07-16 06:51:08 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250714-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-07-14 04:33:25 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250711-0003-Reorganize-tablesync-Code-and-Introduce-sy.patch) at 2025-07-11 09:26:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250709-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-07-09 10:41:22 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250704-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-07-04 10:23:37 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250630-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-06-30 09:50:57 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v20250622-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-06-22 02:35:20 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (vnisha_005-top-up-patch-for-error-message-improvment.patch) at 2025-06-19 05:56:11 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v20250610-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-06-10 03:15:38 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v2025029-0001-Introduce-pg_sequence_state-function-for-en.patch) at 2025-05-29 14:39:13 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250522-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-05-22 17:12:02 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250521-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-05-21 17:34:57 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250516-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-05-16 08:46:19 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250514-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-05-14 04:56:31 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250503-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-05-03 13:57:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250501-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-05-01 03:16:27 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250428-0003-Reorganize-tablesync-Code-and-Introduce-sy.patch) at 2025-04-28 12:56:56 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250424-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-04-24 10:29:46 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250422-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-04-22 06:10:02 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250416-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-04-16 13:29:19 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250414-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-04-14 09:34:57 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250325-0003-Reorganize-tablesync-Code-and-Introduce-sy.patch) at 2025-03-25 05:35:46 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250312-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-03-12 03:44:05 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250203-0005-Documentation-for-sequence-synchronization.patch) at 2025-02-03 05:43:31 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250110-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-01-10 14:37:50 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20250204-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2025-01-04 04:31:07 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20241230-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-12-30 10:10:14 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v202412125-0001-Introduce-pg_sequence_state-function-for-.patch) at 2024-12-25 03:44:11 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v202412123-0003-Reorganize-tablesync-Code-and-Introduce-s.patch) at 2024-12-23 07:20:14 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20241218_SEQ_0001.txt) at 2024-12-18 02:41:57 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20241211-0003-Reorganize-tablesync-Code-and-Introduce-sy.patch) at 2024-12-11 10:12:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20241208-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-12-08 14:27:08 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20241118-0005-Documentation-for-sequence-synchronization.patch) at 2024-11-18 10:19:33 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20241031-0002-Introduce-ALL-SEQUENCES-support-for-Postgr.patch) at 2024-10-31 09:27:35 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20241008-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-10-08 09:45:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240920-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-09-20 04:06:44 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240821-0003-Reorganize-tablesync-Code-and-Introduce-sy.patch) at 2024-08-21 06:24:28 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240821_SEQ_0003.txt) at 2024-08-21 03:02:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240820-0005-Documentation-for-sequence-synchronization.patch) at 2024-08-20 07:44:00 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240819-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-08-19 13:08:17 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240817-0005-Documentation-for-sequence-synchronization.patch) at 2024-08-17 15:10:51 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240816-0005-Documentation-for-sequence-synchronization.patch) at 2024-08-16 05:38:28 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240816_seq_0004.txt) at 2024-08-16 04:55:56 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240815-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-08-15 07:38:53 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240815_SEQ_0004.txt) at 2024-08-15 06:27:01 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240814-0002-Introduce-ALL-SEQUENCES-support-for-Postgr.patch) at 2024-08-14 13:06:11 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240814_SEQ_0004.txt) at 2024-08-14 03:09:07 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240813-0002-Introduce-ALL-SEQUENCES-support-for-Postgr.patch) at 2024-08-13 11:59:49 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240813_SEQ_0003.txt) at 2024-08-13 03:49:26 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240812-0003-Reorganization-of-tablesync-code.patch) at 2024-08-12 13:06:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240812_SEQ_0001.txt) at 2024-08-12 03:20:04 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240809-0003-Enhance-sequence-synchronization-during-su.patch) at 2024-08-09 13:12:41 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_202400809_seq_0004.txt) at 2024-08-09 07:10:08 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240809_seq_0003.txt) at 2024-08-09 00:20:43 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240808-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-08-08 15:52:15 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240808_SEQ_0003.txt) at 2024-08-08 03:00:28 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240807-0001-Introduce-pg_sequence_state-function-for-e.patch) at 2024-08-07 08:15:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240806_SEQ_0003.txt) at 2024-08-06 09:08:00 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240805_2-0001-Introduce-pg_sequence_state-function-for.patch) at 2024-08-05 09:04:34 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240805-0003-Enhance-sequence-synchronization-during-su.patch) at 2024-08-05 04:29:54 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (sequence_perf.txt) at 2024-07-31 09:33:15 from vignesh C <vignesh21 at gmail.com> (Patch: No)
    Attachment (PS_NITPICKS_20240731_SEQ_003.txt) at 2024-07-31 07:25:39 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240730_2-0001-Introduce-pg_sequence_state-function-for.patch) at 2024-07-29 10:47:35 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240729-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-07-29 05:49:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240726_SEQ_0003.txt) at 2024-07-26 06:16:30 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240726_SEQ_0002.txt) at 2024-07-26 02:33:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240725_SEQ_0003.txt) at 2024-07-25 07:24:28 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240725-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-07-25 03:22:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240724-0002-Introduce-ALL-SEQUENCES-support-for-Postgr.patch) at 2024-07-24 06:37:01 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240724_SEQ_0003_DOCS.txt) at 2024-07-24 03:46:52 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240723_SEQ_0002.txt) at 2024-07-23 05:32:50 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240720-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-07-20 15:06:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240712_SEQ_0003.txt) at 2024-07-12 02:52:25 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240710_SEQ_0003_DOCS.txt) at 2024-07-10 08:16:03 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240710_SEQ_0002.txt) at 2024-07-10 04:03:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240705-0003-Enhance-sequence-synchronization-during-su.patch) at 2024-07-05 11:58:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240704-SEQ-0002.txt) at 2024-07-04 07:13:54 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240704-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-07-04 03:35:20 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240704_SEQ_0001.txt) at 2024-07-04 01:09:42 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240703-0002-Introduce-ALL-SEQUENCES-support-for-Postgr.patch) at 2024-07-03 14:39:24 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240703_SEQ_0001.txt) at 2024-07-03 02:54:18 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240702-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-07-02 09:39:59 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240701_SEQ_0002.txt) at 2024-07-01 07:27:22 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240626_SEQ_0001.txt) at 2024-06-26 09:10:39 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20240625-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-06-25 15:39:17 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240620-0002-Introduce-ALL-SEQUENCES-support-for-Postgr.patch) at 2024-06-20 12:53:34 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240619-0001-Introduce-pg_sequence_state-and-SetSequenc.patch) at 2024-06-19 15:03:37 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v20240608-0001-Enable-sequence-synchronization-when-creat.patch) at 2024-06-08 13:13:32 from vignesh C <vignesh21 at gmail.com> (Patch: No)
History
When Who What
2025-09-01 05:59:34 CFbot Patch does not need rebase anymore
2025-08-26 13:37:21 CFbot Patch needs rebase
2025-08-18 02:19:56 Hayato Kuroda (ha-kun) Added ha-kun as reviewer
2025-08-06 11:40:35 CFbot Patch does not need rebase anymore
2025-08-04 11:41:28 CFbot Patch needs rebase
2025-08-01 06:54:36 Hayato Kuroda (ha-kun) Moved from CF PG19-1 to CF PG19-2
2025-06-30 02:00:17 Hayato Kuroda (ha-kun) Changed tags to Logical Replication
2025-06-22 03:05:49 CFbot Patch does not need rebase anymore
2025-06-19 06:03:34 CFbot Patch needs rebase
2025-04-14 03:28:40 CFbot Patch does not need rebase anymore
2025-03-30 10:52:44 CFbot Patch needs rebase
2025-03-25 06:18:52 CFbot Patch does not need rebase anymore
2025-03-14 08:29:37 CFbot Patch needs rebase
2025-03-12 03:59:50 CFbot Patch does not need rebase anymore
2025-03-12 03:56:43 vigneshwaran C (vignesh.postgres) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-12 03:56:20 vigneshwaran C (vignesh.postgres) New status: Needs review
2025-03-11 04:15:00 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-02-21 09:58:38 CFbot Patch needs rebase
2025-02-05 01:01:14 Peter Smith (smithpb2250) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-05 03:41:39 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-05 09:49:22 Andrey Borodin (x4m) Closed in commitfest 2024-09 with status: Moved to next CF
2024-07-29 09:50:30 Sheeraz Majeed (sheeraz) Removed sheeraz from reviewers
2024-07-29 09:50:26 Sheeraz Majeed (sheeraz) Added sheeraz as reviewer
2024-07-05 12:01:18 vigneshwaran C (vignesh.postgres) Changed reviewers to Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Peter Smith (smithpb2250)
2024-07-05 12:01:18 vigneshwaran C (vignesh.postgres) Changed authors to vigneshwaran C (vignesh.postgres)
2024-07-05 12:00:21 vigneshwaran C (vignesh.postgres) Attached mail thread CAA4eK1LC+KJiAkSrpE_NwvNdidw9F2os7GERUeSxSKv71gXysQ@mail.gmail.com
2024-07-05 12:00:21 vigneshwaran C (vignesh.postgres) Created patch record
Edit