PostgreSQL 19 Open Items

Important Dates

Current schedule:

• Beta 2: July 16, 2026
• Beta 1: June 4, 2026
• 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: Please list the Owner of the open item. If you're unsure who the Owner is, by default the owner should be the committer who made the target commit.

• 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

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

• fix FOR PORTION OF with RLS
  • Commit: 8e72d914c528
  • Owner: Peter Eisentraut

• FOR PORTION OF should forbid BEFORE triggers changing the application-time
  • You aren't allowed to SET this in an UPDATE; you shouldn't be allowed to change it with a BEFORE trigger either.
  • Commit: 8e72d914c
  • Owner: Peter Eisentraut / Paul Jungwirth

• FOR PORTION OF should skip leftovers after INSTEAD OF trigger
  • Originally reported here.
  • Commit: 8e72d914c52
  • Owner: Peter Eisentraut / Paul Jungwirth

• FOR PORTION OF should reject GENERATED columns
  • Commit: 8e72d914c52
  • Owner: Peter Eisentraut / Paul Jungwirth

• Fix SET EXPRESSION for virtual columns with whole-row dependencies
  • Commit: f80bedd52
  • Owner: Peter Eisentraut

• postgres_fdw: fix cumulative stats after imported foreign-table stats
  • Commit: 28972b6fc
  • Owner: Etsuro Fujita

• use of SPI by postgresImportForeignStatistics
  • Commit: 28972b6fc
  • Owner: Etsuro Fujita

• Fix GROUP BY ALL handling of ORDER BY operator semantics
  • Commit: ef38a4d97
  • Owner: Tom Lane

• UTF8 LIKE behavior change in refactor commit; 2 other findings
  • Commit: 5a38104
  • Owner: Jeff Davis

• FSM Update Missing when Setting VM On-access
  • Commit: b46e1e54d078de
  • Owner: Melanie Plageman

• Wrong query result w/ propgraph single lateral col reference
  • Commit: 2f094e7
  • Owner: Peter Eisentraut

Resolved Issues

resolved before 19beta2

• NULL pointer dereference in syslogger with load_libraries() and -DEXEC_BACKEND at startup
  • Commit: 0c8e082fba8d
  • Owner: Alvaro Herrera
  • Fix: fb23cc7e81db181bfb3dcfed6ad0731a3473d4e1

• Fix regression in vacuumdb --analyze-in-stages for partitioned tables
  • Commit: c4067383cb2c
  • Owner: Alvaro Herrera
  • Fix: 95b6ec52e684e5de743e5bf4a2303f6cac466682

• SERVICEFILE shows wrong file after servicefile fallback
  • Commit: 092f3c63efc6
  • Owner: Michael Paquier
  • Fix: 90354030b8fc

• Fix tuple deformation with virtual generated NOT NULL columns
  • Commit: c456e3911
  • Owner: David Rowley
  • Fix: 89eafad297a9b01ad77cfc1ab93a433e0af894b0

• pg_createsubscriber: allow duplicate publication names
  • Commit: 85ddcc2f4cde
  • Owner: Amit Kapila
  • Fix: 6ce035ffff444479e63ea6276d56e33cc8b991d9

• Fix REPACK decoding worker not cleaned up on FATAL exit
  • Owner: Álvaro Herrera
  • Commit: 28d534e2ae0ac888b5460f977a10cd9bb017ef98
  • Fix: 0160143ad9a686a7e705348da1f90e63a2a31536

• Fix bug of UPDATE/DELETE FOR PORTION OF with inheritance tables
  • When update/delete a inherited table, leftover rows are wrongly inserted into the parent table.
  • Commit: 8e72d914c528
  • Owner: Peter Eisentraut
  • Fix: 7d13b03a2e677b78047cf537e519166dcbafa117

• Fix race during concurrent logical decoding activation
  • Commit: 67c20979ce7
  • Owner: Masahiko Sawada
  • Fix: 93a3e6839bf8d

• Reject negative max_retention_duration values
  • Commit: a850be2fe
  • Owner: Amit Kapila
  • Fix: 987440b33a511482232c59a190cc16ae4feff9aa

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

• fix FOR PORTION OF not updating dependent generated columns
  • Commit: 8e72d914c528
  • Owner: Peter Eisentraut

• Fix md5_password_warnings for role and database settings
  • Commit: bc60ee860
  • Owner: Nathan Bossart
  • Fix: 44196fd4f378d776c4cd7282256f4d6df03b5734

• BUG #19508: pg_buffercache_pages() crashes the backend with an incompatible caller-supplied record definition
  • Commit: 257c8231bf
  • Owner: Heikki Linnakangas
  • Fix: b70d5672d0c5d4310965fcbc1c846c9d111a3046

• Miscellaneous issues with FK fast path buffering
  • Commit: b7b27eb41
  • Fix: 0e47bb5fbeec64d776d49dee242bac39d4616f8b
  • Fix: 4113873a5ab0fb83a6f772f455b2842359d5ec50
  • Owner: Amit Langote

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

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

• (SQL/PGQ) cache lookup failed for label
  • Commit: 2f094e7ac69
  • Owner: Peter Eisentraut

• Assertion failure in LATERAL GRAPH_TABLE with multi-label pattern
  • Commit: 2f094e7ac69
  • Owner: Peter Eisentraut

• autovacuum mxid score can become infinity
  • Commit: 87f61f0c
  • Owner: Nathan Bossart / Sami Imseih
  • Fix: 1f2297b5

• document standard_conforming_strings dump/restore incompatibility
  • Owner: Tom Lane
  • Commit: 45762084545e
  • Fix: 62c09cdc1

• autovacuum launcher crash: assert in pgstat_count_io_op (IOOP_EXTEND on pg_database's VM)
  • Commit: b46e1e54d078
  • Owner: Melanie Plageman
  • Fix: 4abf411e232

• bytea(uuid) missing proleakproof
  • Commit: ba21f5bf8 ba21f5bf8
  • Owner: Masahiko Sawada
  • Fix: 6468f7a853c

• Improving EXPLAIN (IO) docs
  • Commit: 681daed93169
  • Owner: Tomas Vondra

• non-plain pg_dumpall: multiple defects
  • Owner: Andrew Dunstan
  • Commit: 763aaa0
  • Fix(revert): 7ca548f23a6

• Fix bug of CHECK constraint enforceability recursion
  • Commit: 342051d73b38
  • Owner: Andrew Dunstan
  • Fix: d16be8605f5

• What to do about Fix \crosstabview to honor \pset display_true/display_false?
  • Commit: 645cb44c5 645cb44c5
  • Owner: Álvaro Herrera
  • Fix: 4df5fe3833a87f6629eb888ca5a385bcb0b179d9

• 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
  • Fix: a272a58b942, a40fdf65886

• Fix ALTER DOMAIN VALIDATE CONSTRAINT locking
  • Commit: 16a0039dc
  • Owner: Peter Eisentraut
  • Fix: 64797ad97d6

• FOR PORTION OF should not allow WHERE CURRENT OF
  • Commit: 8e72d914c
  • Owner: Peter Eisentraut / Paul Jungwirth
  • Fix: bc3ae886a75

resolved before 19beta1

• WAL accumulation during REPACK CONCURRENTLY
  • Commit: 28d534e2a
  • Owner: Alvaro Herrera
  • Fix: 45b02984e2fa9ee7bd83f7e58797b160baf0cc13

• Fix errhint messages for REPACK (CONCURRENTLY) restrictions
  • Owner: Álvaro Herrera
  • Commit: 28d534e2ae0ac888b5460f977a10cd9bb017ef98
  • Fix: 3bf63730cb041a834c618082ba3d5e8bf96a31a5

• Re: Speed up ICU case conversion by using ucasemap_utf8To*()
  • Commit: c4ff35f10441de7dbed4e87737bca205dcca698e
  • Fix: 06ce97b9994eca91250d7c28f0df9b1ae7829f36
  • Owner: Jeff Davis

• 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

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

• Bug: trailing comma syntax error in postgres_fdw fetch_attstats()
  • Commit: 28972b6fc3dc954e57708ea6
  • Fix: 3f7a1afbaef0
  • Owner: Etsuro Fujita

• Fix REPACK with WITHOUT OVERLAPS replica identity indexes
  • Commit: 28d534e2ae0a
  • Fix: 36f52a59b315
  • Owner: Álvaro Herrera

• Fix jsonpath .split_part() to honor silent mode
  • Commit: bd4f879a9cdd
  • Fix: 954e57708ea6
  • Owner: Andrew Dunstan

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

• Fix bug of COPY TO support partition table
  • Owner: Masahiko Sawada
  • Commit: 4bea91f21f61
  • Fix: 82f0135a2630

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

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

• Fix IGNORE NULLS nullness cache for volatile window arguments
  • Commit: 2d7b247cb41
  • Fix: 26269fe3c83
  • Owner: Tatsuo Ishii

• Fix SPLIT PARTITION bound-overlap bug
  • Commit: 4b3d173629f4
  • Fix: 9354896920e4
  • Owner: Alexander Korotkov

• Set notice receiver before libpq connection startup
  • Commit: 112faf1378e
  • Fix: 06a5c3cdef02
  • Owner: Fujii Masao

• Fix LISTEN startup race with direct advancement
  • Commit: 282b1cde9dedf456ecf02eb27caf086023a7bb71
  • Fix: 0f24332aeb4f43409c2a7bec9fef1e3317689bc5
  • Owner: Tom Lane

• Startup process deadlock: WaitForProcSignalBarriers vs aux process
  • Commit: 67c20979ce72
  • Fix: d79bf7612a07a6f05
  • Owner: Masahiko Sawada

• Assertion failure in pg_plan_advice with EXISTS subquery and DO_NOT_SCAN advice
  • Commit: 5883ff30b02c
  • Fix: b1901e2895e08f57a5fedfd27375babd6c633893
  • Owner: Robert Haas

• pg_stash_advice dump file overlong stash name crashes worker
  • Commit: c10edb102a
  • Fix: 878839bafe259e6df355e7adc5a040a1541b63b8
  • Owner: Robert Haas

• Avoid leaking system path from pg_available_extensions
  • Commit: f3c9e341cdf1
  • Fix: db5ed03217b
  • Owner: Andrew Dunstan

• Apply ENCODING option for COPY TO FORMAT JSON
  • Commit: 7dadd38cda
  • Fix: 7dc5bbcf220
  • Owner: Andrew Dunstan

Non-bugs

• No method to block effective_wal_level=logical when wal_level=replica is needed
  • the REPLICATION privilege already grants very powerful capabilities, including the ability to read all data via physical streaming and to hold back horizons. A user trusted with REPLICATION is already trusted enough that allowing them to create a logical slot does not represent a fundamentally new class of risk.

Won't Fix

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

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
• ALTER COLUMN SET EXPRESSION need cope with whole-row references

See also

• Release Management Team
• PostgreSQL 18 Open Items