PostgreSQL 19 Open Items

Important Dates

Current schedule:

• Feature Freeze: April 8, 2026 12:00 UTC

Decisions to Recheck Mid-Beta

• Do we want to keep the assertions added by commit 7dcea51c2a4d
  • Owner: Álvaro Herrera

• When exactly should we revert protocol grease?
  • Owner: Jacob Champion

Open Issues

• No method to block effective_wal_level=logical when wal_level=replica is needed

• Revert the beta-only grease patch (4966bd3ed) before RC1.
  • Owner: Jacob Champion

• BM_IO_ERROR flag is lost in TerminateBufferIO due to order of operations in UnlockBufHdrExt
  • Commit: c75ebc657ffc ?
  • Owner: Andres Freund

• UPDATE/DELETE FOR PORTION OF with rule system is not working
  • Commit: 8e72d914c52
  • Owner: Peter Eisentraut / Paul Jungwirth

• UPDATE/DELETE FOR PORTION OF updatable view some case not working
  • Commit: 8e72d914c52
  • Owner: Peter Eisentraut / Paul Jungwirth

• Should FOR PORTION OF use null values for unbounded ranges or a separate keyword?
  • Commit: 8e72d914c52
  • Owner: Peter Eisentraut / Paul Jungwirth

• GetLocalPinLimit() is too aggressive making it easy for backend to run out of pins
  • Easier to hit after 378a216187aea1 but not caused by this
  • Owner: Melanie Plageman

• What to do about concurrent repack lock upgrade?
  • Owner: Álvaro Herrera
  • Commit: 28d534e2ae0ac888b5460f977a10cd9bb017ef98

• WAIT FOR LSN crashes with assertion failure inside PL/pgSQL DO blocks and procedures
  • Owner: Alexander Korotkov
  • Commit: 447aae13b030

• Inconsistent trigger behavior between two temporal leftovers
  • Commit: 8e72d914c52
  • Owner: Peter Eisentraut / Paul Jungwirth

• Bug: trailing comma syntax error in postgres_fdw fetch_attstats()
  • Commit: 28972b6fc3dc
  • Owner: Etsuro Fujita

• Fix array-element quoting in postgres_fdw import statistics
  • Commit: 28972b6fc3dc
  • Owner: Etsuro Fujita

• Re: Speed up ICU case conversion by using ucasemap_utf8To*()
  • Commit: c4ff35f10441de7dbed4e87737bca205dcca698e
  • Owner: Andreas Karlsson

• Coverity: Improper use of strncpy()
  • Commit: 28972b6fc3dc
  • Owner: Etsuro Fujita

• COPY TO FORMAT JSON does not handle generated column properly
  • Commit: 7dadd38cda95
  • Owner: jian he

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

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

Resolved Issues

resolved before 19beta1

• Add tests for locks statistics
  • Commit: 7c64d56fd9765bb577937c07eabed971e605c67c removed the tests as unstable in the CI for Windows, at least.
  • Fix: 557a9f1e3e62
  • Owner: Michael Paquier

• Deferred foreign key checks mistakenly don't use batched path
  • Commit: b7b27eb41a5
  • Fix: 5c54c3ed1b934
  • Owner: Amit Langote

• pg_upgrade fails when extension_control_path is used
  • Commit: 4f7f7b0375854e2f89876473405a8f21c95012af added this feature to 18; upgrading to 19 fails.
  • Fix: 1e67508730e
  • Owner: Peter Eisentraut

• Fast-path FK batch path crashes under nested SPI from C extensions (resource owner mismatch).
  • Commit: b7b27eb41a5
  • Fix: 34a307862930
  • Owner: Amit Langote

• FK fast path check column order mismatach
  • Commit: 2da86c1ef9b54
  • Fix: 980c1a85d81
  • Owner: Amit Langote / Junwang Zhao

Older bugs affecting stable branches

Live issues

• Non-parallel-aware parallel bitmap table scan's EXPLAIN ANALYZE does not report exact/lossy pages
  • Fixed in master in 9c18b47e610 and should likely be fixed in backbranches (but with a different approach)
  • Owner: Melanie Plageman/Tomas Vondra

• ALTER TABLE DROP COLUMN should drop whole-row referenced object

• disallow altering column if partition key contains wholerow reference

• ATPostAlterTypeCleanup should not call twice

• Reject ADD CONSTRAINT NOT NULL if name mismatches existing domain not-null constraint

• examine_variable ignored CollateExpr

See also

• Release Management Team
• PostgreSQL 18 Open Items