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

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

NOTE: The owner of an open item is by default the committer of the culprit commit.

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

• 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 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

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

• 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: Jeff Davis

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

• transformForPortionOfClause performs various checks too early
  • It mustn't check properties that could change between parsing and execution of a function containing FOR PORTION OF.
  • Commit: 8e72d914c
  • Owner: Peter Eisentraut / Paul Jungwirth

• Startup process deadlock: WaitForProcSignalBarriers vs aux process
  • Signals (including ProcSignalBarrier signals) are sent to aux processes before the aux process starts listening for them. The aux process can thus miss the signal to act on a ProcSignalBarrier, which causes the requesting process (this case: startup process) to wait forever.
  • The trigger for this deadlock was introduced in 67c20979ce72 (new in 19), but signals have been blackholed by auxiliary processes for a much longer time.
  • Owner: Masahiko Sawada

• Fix DROP PROPERTY GRAPH "unsupported object class" error
  • It's failing when an event trigger is active.
  • Commit: 2f094e7ac69
  • Owner: Peter Eisentraut

• Not leak UID to psql client
  • Commit: 55890a91945
  • Owner: Andrew Dunstan

• Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server
  • Commit: 8185bb53476
  • Owner: Jeff Davis

Resolved Issues

resolved before 19beta1

• Compressed TOAST data corruption with REPACK CONCURRENTLY
  • Commit: 28d534e2ae0a
  • Owner: Álvaro Herrera

• CI reports 038_walsnd_shutdown_timeout failure on FreeBSD
  • Commit: a8f45dee917
  • Fix: c0b24b32b0d
  • Owner: Fujii Masao

• 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

• COPY TO FORMAT JSON does not handle generated column properly
  • Commit: 7dadd38cda95
  • Fix: f30d0c720f2ec
  • Owner: Andrew Dunstan

• 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

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

• REPACK should not fallback to use deferrable primary key concurrent mode
  • Commit: 28d534e2ae0
  • Fix: 832e220d99a
  • Owner: Alvaro Herrera

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

• Inconsistencies with Datum conversions
  • Second report
  • Commit: 6dcfac9696cb
  • Fix: ac59a90bef45
  • Owner: Michael Paquier

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

• type cast disallow UNKNOWN target types

See also

• Release Management Team
• PostgreSQL 18 Open Items