PostgreSQL 17 Open Items

Open Issues

NOTE: Please place new open items at the end of the list.

NOTE: If known, please list the Owner of the open item.

• DROP OWNED BY fails to clean out pg_init_privs grants
  • Probably dates to the introduction of pg_init_privs

• Incorrect Assert in heap_end/rescan for BHS
  • Commit: 04e72ed617be
  • Owners: Melanie Plageman, Tomas Vondra

• aminsertcleanup fails to release buffers during reindex
  • Commit: c1ec02be1d
  • Owner: Tomas Vondra

• Register ALPN protocol id with IANA
  • Thread on IETF mailing list
  • Commit: 91044ae4ba
  • Owner: Heikki Linnakangas

• Rework tests of test_json_parser
  • Commit: 3311ea86edc7
  • Owner: Andrew Dunstan

• backtrace_on_internal_error lacks extensibility
  • Commit: a740b213d4b
  • Owner: Peter Eisentraut

• dump/restores not able to handle AM for partitioned tables
  • Commit: 374c7a229042
  • Owner: Alvaro Herrera (committer), Michael Paquier (author)

• not null constraints break dump/restore
  • Commit: b0e96f3119
  • Owner: Alvaro Herrera
  • Prior report

• fix tablespace handling in pg_combinebackup
  • Commit: dc212340058b
  • Owner: Robert Haas

• checksums vs. incremental backup
  • Commit: dc212340058b
  • Owner: Robert Haas

• Rework handling of failover option in transaction block for ALTER SUBSCRIPTION
  • Commit: 776621a5e479
  • Owner: Amit Kapila

Older bugs affecting stable branches

Live issues

• Assert in expandTupleDesc() fails on row mismatch with additional SRF
  • Affects all supported branches

• long-standing data loss bug in initial sync of logical replication
  • Affects 11+ (probably)

• Intermittent failures in 040_standby_failover_slots_sync test
  • Possible solution in this thread: Race condition in FetchTableStates
  • Affects 15+ (probably)

• relfrozenxid may disagree with row XIDs after 1ccc1e05ae
  • Commit: 1ccc1e05ae
  • We have no test case to confirm the hypothesis that 1ccc1e05ae made things worse.
  • It seems likely that there are or have been bugs in this area for a while, but it is not clear that anything is worse in 17.
  • Owner: Robert Haas

Resolved Issues

resolved before 17beta1

• pg_upgrade with --link mode failing upgrade of publishers
  • Original Commit: 29d0a77fa6606f9c01ba17311fc452dabd3f793d
  • Fixed at: f17529b710977c6ae89a1bc141cd1fb587953cc3

• Rethink automated wait events when it comes to backpatching
  • Original Commit: fa88928470b5
  • Fixed at: f98dbdeb51d1

• Make injection points more easily concurrent-safe
  • Original Commit: d86d20f0ba79
  • Fixed at: f587338dec87

• Revisit implementation choices of ReorderBuffer eviction algorithm
  • Original Commit: 5bec1d6bc5e3, b840508644, bcb14f4abc
  • Fixed at: efb8acc0d0, 810f64a015

• Incorrect handling of IS [NOT] NULL quals on inheritance parents
  • Original Commit: b262ad440edecda0b1aba81d967ab560a83acb8a
  • Fixed at: 3af7040985b6df504a72cd307aad5d69ac5f5384

• Synced slot:change could be missing after promotion
  • Commit: ddd5f4f54a
  • Fixed at: 2ec005b4e2

• unnecessary differences between btree/brin in parallel CREATE INDEX
  • Commit: b43757171470
  • Owner: Tomas Vondra

• Problems with deparsed SQL/JSON query function
  • Commit: 6185c9737cf
  • Fixed at: c0fc0751862

• Improve some error messages for JSON_TABLE() by mentioning column name
  • Commit: de3600452b61d
  • Fixed at: b4fad46b6bc8

• pg_combinebackup does not detect missing files
  • Commit: dc212340058b
  • The behavior is intentional but we have improved the documentation in 2e2d4604d94318a304d350aee478bda91a521339
  • Owner: Robert Haas

Important Dates

Current schedule:

• GA: XX
• RC 1: XX
• Beta 3: XX
• Beta 2: XX
• Beta 1: XX
• Feature Freeze: April 8, 2024 0:00 AoE

See also

• Release Management Team
• PostgreSQL 16 Open Items