Jun - Jul 2026

7 commits
Avoid reporting permission-denied publisher sequences as missing
25 Jul 2026Fujii MasaomasterunreleasedREL_19_STABLE19beta3
LLM analysis, 100% surelanded as postedfrom patchset #301 of 1 reviewer saw the final version

The sequencesync.c diff exactly matches #30, including the found_on_pub assignment and revised explanation of false versus NULL privilege results.

  • Fujii Masaosaw the final versiontrailerFujii approved the logic and supplied the comment correction in #29, then committed the revised patch and confirmed it in #31.
Handle concurrent sequence drops during synchronization
16 Jul 2026Fujii MasaomasterunreleasedREL_19_STABLE19beta3Also in: sequencesync worker race with REFRESH SEQUENCES (not this thread)
LLM analysis, 100% suremodified before commitlight changesfrom patchset #263 of 3 reviewers saw the final version

The commit matches #26, with only comment refinements in src/backend/replication/logical/sequencesync.c and comments plus an AccessShareLock filter in src/test/subscription/t/036_sequences.pl. The current verdict for thread #253039 confirms that it supplied the report but no matching attachment, supporting attribution to this thread.

  • Hayato Kurodasaw the final versiontrailerHayato connected a buildfarm crash to the same race and endorsed the fix in #23, after which only conversion-order cleanup, comments, and test refinements followed.
  • Zsolt Parragisaw the final versiontrailerZsolt reported local reproduction, endorsed the fix, and supplied a deterministic verification test in #25, after which only cleanup and test refinements followed.
  • Fujii Masaosaw the final versiontrailerFujii requested checking NULL before conversion and retaining explanatory comments in #24, then committed the revised patch as confirmed in #27.
Add hints for sequence synchronization permission warnings
8 Jul 2026Fujii MasaomasterunreleasedREL_19_STABLE19beta2
LLM analysis, 100% surelanded as postedfrom patchset #182 of 2 reviewers saw the final version

Both the sequencesync.c hints and logical-replication.sgml changes match #18; differences are limited to documentation base hashes and hunk offsets.

  • Amit Kapilasaw the final versiontrailerAmit proposed grant hints in #6, agreed with the refined role wording in #8, and gave the revised patch an LGTM in #19.
  • Bharath Rupireddysaw the final versiontrailerBharath explicitly approved the hints patch in #10, followed only by pluralization, comments, and documentation organization in #18.
doc: Clarify pg_get_sequence_data() NULL-return cases
8 Jul 2026Fujii MasaomasterunreleasedREL_19_STABLE19beta2
LLM analysis, 100% surelanded as postedfrom patchset #191 of 1 reviewer saw the final version

The func-sequence.sgml diff exactly matches Amit Kapila's attachment in #19, enumerating NULL-return cases and removing the redundant SELECT-privilege sentence.

  • Fujii Masaosaw the final versiontrailerFujii developed the clarified wording in #18 and reviewed and committed Amit's attachment, confirming the push in #20.
Fix unlogged sequence corruption after standby promotion
29 Jun 2026Fujii MasaomasterunreleasedREL_19_STABLE19beta2REL_18_STABLE18.6REL_17_STABLE17.11REL_16_STABLE16.15REL_15_STABLE15.19
LLM analysis, 100% surelanded as postedfrom patchset #151 of 1 reviewer saw the final version

All six changed files match #15, including XLogFlushBufferForRedoIfInit(), its sequence/hash callers, and the nextval() recovery test.

  • vignesh Csaw the final versiontrailerVignesh verified the initial fix and requested a test in #14, then tested the revised patches across supported branches and approved them in #16.
doc: Clarify pg_get_sequence_data() privileges and NULL results
20 Jun 2026Fujii Masaomaster19beta2REL_19_STABLE19beta2
LLM analysis, 98% surepart of a posted patchsetlight changesfrom patchset #31 of 1 reviewer saw the final version

Lands exactly the documentation component of the two-patch series in #3, with no changes to its func-sequence.sgml diff; the implementation component landed separately.

  • Tristan Partinsaw the final versiontrailerTristan explicitly endorsed correcting the documentation in #2 and approved the updated series in #4.
Fix misreporting of publisher sequence permissions during sync
20 Jun 2026Fujii Masaomaster19beta2REL_19_STABLE19beta2
LLM analysis, 98% surepart of a posted patchsetlight changesfrom patchset #31 of 1 reviewer saw the final version

Lands exactly the implementation-and-test component of #3, including the privilege column and separate publisher/subscriber warnings; the series' documentation component landed separately.

  • Tristan Partinsaw the final versiontrailerTristan reviewed the initial patch and suggested clearer test wording in #2, then approved the revised series in #4.

Credits across 7 commits

Author
Fujii Masao4
vignesh C2
Amit Kapila1
Reviewer
Fujii Masao3
Tristan Partin2
Amit Kapila1
Bharath Rupireddy1
Hayato Kuroda (Fujitsu)1
vignesh C1
Zsolt Parragi1
Reported by
Noah Misch2
Committer
Fujii Masao7