pg_upgrade fails when FK constraint with same name exists on partitioned table and its partition

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 3, First patch: +106−0, All patches: +238−0

Tags

Bugfix

Created

2026-07-27 09:18:41

Last modified

2026-10-02 03:00:20 (1 month ago)

Latest email

2026-11-10 23:33:31 (3 days ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF

Target version

Authors

Arseny Kositsin (arseny114)

Reviewers

Committer

Links

Emails

pg_upgrade fails when FK constraint with same name exists on partitioned table and its partition: First at 2026-06-08 08:46:14 by Arseny Kositsin <a.kositsyn at postgrespro.ru>
Latest at 2026-11-10 23:33:31 by João Rito <joaovictor.rito at gmail.com>
Latest attachment (v2-0002-pg_upgrade-clearer-report-and-hint-for-duplicate-FK-.patch) at 2026-11-10 23:33:31 from João Rito <joaovictor.rito at gmail.com>
Attachment (v2-0002-pg_upgrade-clearer-report-and-hint-for-duplicate-FK-.patch) at 2026-11-10 23:33:31 from João Rito <joaovictor.rito at gmail.com> (Patch: No)
Attachment (v1-pg_upgrade-check-for-duplicate-FK-names-on-partition.patch) at 2026-07-23 13:47:00 from Arseny Kositsin <a.kositsyn at postgrespro.ru> (Patch: No)

History

When	Who	What
2026-10-02 03:00:20	shihao zhong (zhong950419)	Moved from CF PG20-2 to CF PG20-3
2026-07-27 09:19:32	Arseny Kositsin (arseny114)	Changed targetversion to None
2026-07-27 09:18:41	Arseny Kositsin (arseny114)	Attached mail thread bcbd40ec-9914-4a12-b750-e997dca0442e@postgrespro.ru
2026-07-27 09:18:41	Arseny Kositsin (arseny114)	Created patch record