Movatterモバイル変換

Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding (Noah Misch, Andres Freund)§§

While unlikely, a SIGSEGV crash could occur if an incomplete multibyte character appeared at the end of memory. This was possible both in the server and inlibpq-using applications. (CVE-2025-4207)

Handle self-referential foreign keys on partitioned tables correctly (Álvaro Herrera)§

Creating or attaching partitions failed to make the required catalog entries for a foreign-key constraint, if the table referenced by the constraint was the same partitioned table. This resulted in failure to enforce the constraint fully.

To fix this, you should drop and recreate any self-referential foreign keys on partitioned tables, if partitions have been created or attached since the constraint was created. Bear in mind that violating rows might already be present, in which case recreating the constraint will fail, and you'll need to fix up those rows before trying again.

Fix unexpected“attribute has wrong type” errors inUPDATE,DELETE, andMERGE queries that use whole-row table references to views or functions inFROM (Tom Lane)§§§

Correctly process references to outer CTE names that appear within aWITH clause attached to anINSERT/UPDATE/DELETE/MERGE command that's insideWITH (Tom Lane)§

The parser failed to detect disallowed recursion cases, nor did it account for such references when sorting CTEs into a usable order.

FixARRAY(subquery) andARRAY[expression, ...] constructs to produce sane results when the input is of typeint2vector oroidvector (Tom Lane)§

This patch restores the behavior that existed beforePostgreSQL 9.5: the result is of typeint2vector[] oroidvector[].

Fix possible erroneous reports of invalid affixes while parsingIspell dictionaries (Jacob Brazeal)§

FixALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default (Jian He, Tom Lane, Tender Wang)§§

If a domain type has a default, adding a column of that type (without any explicitDEFAULT clause) failed to install the domain's default value in existing rows, instead leaving the new column null.

Improve the error message for disallowed attempts to alter the properties of a foreign key constraint (Álvaro Herrera)§

Avoid error when resetting therelhassubclass flag of a temporary table that's markedON COMMIT DELETE ROWS (Noah Misch)§

Disable“skip fetch” optimization in bitmap heap scan (Matthias van de Meent)§

It turns out that this optimization can result in returning dead tuples when a concurrent vacuum marks a page all-visible.

Fix performance issues in GIN index search startup when there are many search keys (Tom Lane, Vinod Sridharan)§§

An indexable clause with many keys (for example,jsonbcol ?| array[...] with tens of thousands of array elements) took O(N²) time to start up, and was uncancelable for that interval too.

Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing (Álvaro Herrera)§

Fix race condition in handling ofsynchronous_standby_names immediately after startup (Melnikov Maksim, Michael Paquier)§

For a short period after system startup, backends might fail to wait for synchronous commit even thoughsynchronous_standby_names is enabled.

Fixpg_strtof() to not crash with null endptr (Alexander Lakhin, Tom Lane)§

Avoid crash when a Snowball stemmer encounters an out-of-memory condition (Maksim Korotkov)§

Skip WAL recycling and preallocation during archive recovery, to avoid corruption of WAL files that were restored from the archive (Noah Misch, Arun Thirupathi)§§§§§§§

This change back-patches v15-era fixes that were considered largely cosmetic at the time, but turn out to prevent data corruption in the wake of subsequent fixes.

Prevent over-advancement of catalog xmin in“fast forward” mode of logical decoding (Zhijie Hou)§

This mistake could allow deleted catalog entries to be vacuumed away even though they were still potentially needed by the WAL-reading process.

Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated (Shlok Kyal, Hayato Kuroda)§§

The catalog changes caused by the DDL command were not reflected into WAL-decoding processes, allowing them to decode subsequent changes using stale catalog data, probably resulting in data corruption.

Avoid duplicate snapshot creation in logical replication index lookups (Heikki Linnakangas)§§

Fix overly-strict assertion ingistFindCorrectParent() (Heikki Linnakangas)§

In PL/pgSQL, avoid“unexpected plan node type” error when a scrollable cursor is defined on a simpleSELECTexpression query (Andrei Lepikhov)§

Don't try to drop individual index partitions inpg_dump's--clean mode (Jian He)§

The server rejects suchDROP commands. That has no real consequences, since the partitions will go away anyway in the subsequentDROPs of either their parent tables or their partitioned index. However, the error reported for the attempted drop causes problems when restoring in--single-transaction mode.

Inpg_dumpall, avoid emitting invalid roleGRANT commands ifpg_auth_members contains invalid role OIDs (Tom Lane)§

Instead, print a warning and skip the entry. This copes better with catalog corruption that has been seen to occur in back branches as a result of race conditions betweenGRANT andDROP ROLE.

Allowcontrib/dblink queries to be interrupted by query cancel (Noah Misch)§§

This change back-patches a v17-era fix. It prevents possible hangs inCREATE DATABASE andDROP DATABASE due to failure to detect deadlocks.

Avoid crashing with corrupt input data incontrib/pageinspect'sheap_page_items() (Dmitry Kovalenko)§

Prevent assertion failure incontrib/pg_freespacemap'spg_freespacemap() (Tender Wang)§

Applyingpg_freespacemap() to a relation lacking storage (such as a view) caused an assertion failure, although there was no ill effect in non-assert builds. Add an error check to reject that case.

Fix build failure on macOS 15.4 (Tom Lane, Peter Eisentraut)§

This macOS update broke our configuration probe forstrchrnul().

Update time zone data files totzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran (Tom Lane)§

There is a new time zone America/Coyhaique for Chile's Aysén Region, to account for it changing to UTC-03 year-round and thus diverging from America/Santiago.