DocumentationVersion comparison
POSTGRESQL · VERSION COMPARE
PostgreSQL 13.12 release changes
All features, fixes, and compatibility notes in this release, with related records from other versions.
Includes changes after the source version through the target. A major version name means its initial release.
Detect the source version from your database
Complete release changes
13.12
2023-08-10
13.12stableSupport ends 2025-11-13
Security changes
| CVE / issue | Severity | Fixed version | Selection status |
|---|---|---|---|
| CVE-2023-39417 Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign | 13.12 | Recorded fix |
PostgreSQL 13.12
Migration and compatibility
A dump/restore is not required for those running 13.X.
However, if you use BRIN indexes, it may be advisable to reindex them; see the second changelog entry below.
Also, if you are upgrading from a version earlier than 13.7, see Section E.17.
SecurityDisallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign
Changes
Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign (Noah Misch) §
This restriction guards against SQL-injection hazards for trusted extensions.
The PostgreSQL Project thanks Micah Gates, Valerie Woolard, Tim Carey-Smith, and Christoph Berg for reporting this problem. (CVE-2023-39417)
Related records (4)
- Same changePostgreSQL 15.4 · Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign
- Same changePostgreSQL 14.9 · Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign
- Same changePostgreSQL 12.16 · Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign
- Same changePostgreSQL 11.21 · Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign
Bug fixesFix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries
Changes
Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries (Tomas Vondra) § §
Each of these oversights could result in forgetting that a BRIN index range contains any NULL values, potentially allowing subsequent queries that should return NULL values to miss doing so.
This fix will not in itself correct faulty BRIN entries. It's recommended to REINDEX any BRIN indexes that may be used to search for nulls.
Related records (4)
- Same changePostgreSQL 15.4 · Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries
- Same changePostgreSQL 14.9 · Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries
- Same changePostgreSQL 12.16 · Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries
- Same changePostgreSQL 11.21 · Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries
Bug fixesAvoid leaving a corrupted database behind when DROP DATABASE is interrupted
Changes
Avoid leaving a corrupted database behind when DROP DATABASE is interrupted (Andres Freund) §
If DROP DATABASE was interrupted after it had already begun taking irreversible steps, the target database remained accessible (because the removal of its pg_database row would roll back), but it would have corrupt contents. Fix by marking the database as inaccessible before we begin to perform irreversible operations. A failure after that will leave the database still partially present, but nothing can be done with it except to issue another DROP DATABASE.
Related records (4)
- Same changePostgreSQL 15.4 · Avoid leaving a corrupted database behind when DROP DATABASE is interrupted
- Same changePostgreSQL 14.9 · Avoid leaving a corrupted database behind when DROP DATABASE is interrupted
- Same changePostgreSQL 12.16 · Avoid leaving a corrupted database behind when DROP DATABASE is interrupted
- Same changePostgreSQL 11.21 · Avoid leaving a corrupted database behind when DROP DATABASE is interrupted
ImprovementsEnsure that partitioned indexes are correctly marked as valid or not at creation
Changes
Ensure that partitioned indexes are correctly marked as valid or not at creation (Michael Paquier) §
If a new partitioned index matches an existing but invalid index on one of the partitions, the partitioned index could end up being marked valid prematurely. This could lead to misbehavior or assertion failures in subsequent queries on the partitioned table.
Related records (4)
- Same changePostgreSQL 15.4 · Ensure that partitioned indexes are correctly marked as valid or not at creation
- Same changePostgreSQL 14.9 · Ensure that partitioned indexes are correctly marked as valid or not at creation
- Same changePostgreSQL 12.16 · Ensure that partitioned indexes are correctly marked as valid or not at creation
- Same changePostgreSQL 11.21 · Ensure that partitioned indexes are correctly marked as valid or not at creation
ImprovementsIgnore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION
Changes
Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION (Michael Paquier) §
Such an index will now be ignored, and a new child index created instead.
Related records (4)
- Same changePostgreSQL 15.4 · Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION
- Same changePostgreSQL 14.9 · Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION
- Same changePostgreSQL 12.16 · Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION
- Same changePostgreSQL 11.21 · Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION
Bug fixesFix possible failure when marking a partitioned index valid after all of its partitions have been attached
Changes
Fix possible failure when marking a partitioned index valid after all of its partitions have been attached (Michael Paquier) §
The update of the index's pg_index entry could use stale data for other columns. One reported symptom is an “attempted to update invisible tuple” error.
Related records (4)
- Same changePostgreSQL 15.4 · Fix possible failure when marking a partitioned index valid after all of its partitions have been attached
- Same changePostgreSQL 14.9 · Fix possible failure when marking a partitioned index valid after all of its partitions have been attached
- Same changePostgreSQL 12.16 · Fix possible failure when marking a partitioned index valid after all of its partitions have been attached
- Same changePostgreSQL 11.21 · Fix possible failure when marking a partitioned index valid after all of its partitions have been attached
Bug fixesFix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema
Changes
Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema (Michael Paquier, Heikki Linnakangas) §
Erroring out if the extension contains objects in multiple schemas was always intended; but the check was mis-coded so that it would fail to detect some cases, leading to surprising behavior.
Related records (4)
- Same changePostgreSQL 15.4 · Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema
- Same changePostgreSQL 14.9 · Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema
- Same changePostgreSQL 12.16 · Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema
- Same changePostgreSQL 11.21 · Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema
ImprovementsDon't use partial unique indexes for uniqueness proofs in the planner
Changes
Don't use partial unique indexes for uniqueness proofs in the planner (David Rowley) §
This could give rise to incorrect plans, since the presumed uniqueness of rows read from a table might not hold if the index in question isn't used to scan the table.
Related records (4)
- Same changePostgreSQL 15.4 · Don't use partial unique indexes for uniqueness proofs in the planner
- Same changePostgreSQL 14.9 · Don't use partial unique indexes for uniqueness proofs in the planner
- Same changePostgreSQL 12.16 · Don't use partial unique indexes for uniqueness proofs in the planner
- Same changePostgreSQL 11.21 · Don't use partial unique indexes for uniqueness proofs in the planner
ImprovementsAvoid producing incorrect plans for foreign joins with pseudoconstant join clauses
Changes
Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses (Etsuro Fujita) §
The planner currently lacks support for attaching pseudoconstant join clauses to a pushed-down remote join, so disable generation of remote joins in such cases. (A better solution will require ABI-breaking changes of planner data structures, so it will have to wait for a future major release.)
Related records (4)
- Same changePostgreSQL 15.4 · Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses
- Same changePostgreSQL 14.9 · Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses
- Same changePostgreSQL 12.16 · Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses
- Same changePostgreSQL 11.21 · Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses
ImprovementsCorrectly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions
Changes
Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions (Tom Lane) §
Related records (4)
- Same changePostgreSQL 15.4 · Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions
- Same changePostgreSQL 14.9 · Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions
- Same changePostgreSQL 12.16 · Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions
- Same changePostgreSQL 11.21 · Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions
Bug fixesFix race conditions in conflict detection for SERIALIZABLE isolation mode
Changes
Fix race conditions in conflict detection for SERIALIZABLE isolation mode (Thomas Munro) § § §
Conflicts could be missed when using bitmap heap scans, when using GIN indexes, and when examining an initially-empty btree index. All these cases could lead to serializability failures due to improperly allowing conflicting transactions to commit.
Related records (4)
- Same changePostgreSQL 15.4 · Fix race conditions in conflict detection for SERIALIZABLE isolation mode
- Same changePostgreSQL 14.9 · Fix race conditions in conflict detection for SERIALIZABLE isolation mode
- Same changePostgreSQL 12.16 · Fix race conditions in conflict detection for SERIALIZABLE isolation mode
- Same changePostgreSQL 11.21 · Fix race conditions in conflict detection for SERIALIZABLE isolation mode
Bug fixesFix hash join with an inner-side hash key that contains Params coming from an outer nested loop
Changes
Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop (Tom Lane) §
When rescanning the join after the values of such Params have changed, we must rebuild the hash table, but neglected to do so. This could result in missing join output rows.
Related records (3)
- Same changePostgreSQL 15.4 · Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop
- Same changePostgreSQL 14.9 · Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop
- Same changePostgreSQL 12.16 · Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop
Bug fixesFix intermittent failures when trying to update a field of a composite column
Changes
Fix intermittent failures when trying to update a field of a composite column (Tom Lane) §
If the overall value of the composite column is wide enough to require out-of-line toasting, then an unluckily-timed cache flush could cause errors or server crashes.
Related records (4)
- Same changePostgreSQL 15.4 · Fix intermittent failures when trying to update a field of a composite column
- Same changePostgreSQL 14.9 · Fix intermittent failures when trying to update a field of a composite column
- Same changePostgreSQL 12.16 · Fix intermittent failures when trying to update a field of a composite column
- Same changePostgreSQL 11.21 · Fix intermittent failures when trying to update a field of a composite column
Bug fixesPrevent query-lifespan memory leaks in some UPDATE queries with triggers
Changes
Related records (3)
- Same changePostgreSQL 15.4 · Prevent query-lifespan memory leaks in some UPDATE queries with triggers
- Same changePostgreSQL 14.9 · Prevent query-lifespan memory leaks in some UPDATE queries with triggers
- Same changePostgreSQL 12.16 · Prevent query-lifespan memory leaks in some UPDATE queries with triggers
Bug fixesPrevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned
Changes
Prevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned (James Coleman, Laurenz Albe, Tom Lane) §
ImprovementsAccept fractional seconds in the input to jsonpath's datetime() method
Changes
Accept fractional seconds in the input to jsonpath's datetime() method (Tom Lane) §
Bug fixesPrevent stack-overflow crashes with very complex text search patterns
Changes
Prevent stack-overflow crashes with very complex text search patterns (Tom Lane) §
Related records (4)
- Same changePostgreSQL 15.4 · Prevent stack-overflow crashes with very complex text search patterns
- Same changePostgreSQL 14.9 · Prevent stack-overflow crashes with very complex text search patterns
- Same changePostgreSQL 12.16 · Prevent stack-overflow crashes with very complex text search patterns
- Same changePostgreSQL 11.21 · Prevent stack-overflow crashes with very complex text search patterns
ImprovementsAllow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf
Changes
Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf (Tom Lane) §
The previous limit of 256 bytes has been found insufficient for some use-cases.
Related records (5)
- Related commitsPostgreSQL 16.0 · Allow pg_hba.conf tokens to be of unlimited length
- Same changePostgreSQL 15.4 · Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf
- Same changePostgreSQL 14.9 · Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf
- Same changePostgreSQL 12.16 · Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf
- Same changePostgreSQL 11.21 · Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf
Bug fixesFix mishandling of C++ out-of-memory conditions
Changes
Fix mishandling of C++ out-of-memory conditions (Heikki Linnakangas) §
If JIT is in use, running out of memory in a C++ new call would lead to a PostgreSQL FATAL error, instead of the expected C++ exception.
Related records (4)
- Same changePostgreSQL 15.4 · Fix mishandling of C++ out-of-memory conditions
- Same changePostgreSQL 14.9 · Fix mishandling of C++ out-of-memory conditions
- Same changePostgreSQL 12.16 · Fix mishandling of C++ out-of-memory conditions
- Same changePostgreSQL 11.21 · Fix mishandling of C++ out-of-memory conditions
Bug fixesFix rare null-pointer crash in plancache.c
ImprovementsAvoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space
Changes
Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space (Dongming Liu) §
Ensure that the segment is moved into the appropriate “bin” for its new amount of free space, so that it will be found by subsequent searches.
Related records (4)
- Same changePostgreSQL 15.4 · Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space
- Same changePostgreSQL 14.9 · Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space
- Same changePostgreSQL 12.16 · Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space
- Same changePostgreSQL 11.21 · Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space
ImprovementsAllow VACUUM to continue after detecting certain types of b-tree index corruption
Changes
Allow VACUUM to continue after detecting certain types of b-tree index corruption (Peter Geoghegan) § §
If an invalid sibling-page link is detected, log the issue and press on, rather than throwing an error as before. Nothing short of REINDEX will fix the broken index, but preventing VACUUM from completing until that is done risks making matters far worse.
Related records (4)
- Same changePostgreSQL 15.4 · Allow VACUUM to continue after detecting certain types of b-tree index corruption
- Same changePostgreSQL 14.9 · Allow VACUUM to continue after detecting certain types of b-tree index corruption
- Same changePostgreSQL 12.16 · Allow VACUUM to continue after detecting certain types of b-tree index corruption
- Same changePostgreSQL 11.21 · Allow VACUUM to continue after detecting certain types of b-tree index corruption
ImprovementsEnsure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid
Changes
Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid (Andres Freund) §
Failure to release this lock could lead to a deadlock later, although the lock would be cleaned up if the session exits or encounters some other error.
Related records (4)
- Same changePostgreSQL 15.4 · Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid
- Same changePostgreSQL 14.9 · Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid
- Same changePostgreSQL 12.16 · Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid
- Same changePostgreSQL 11.21 · Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid
Bug fixesAvoid double replay of prepared transactions during crash recovery
Changes
Avoid double replay of prepared transactions during crash recovery (suyu.cmj, Michael Paquier) § §
After a crash partway through a checkpoint with some two-phase transaction state data already flushed to disk by this checkpoint, crash recovery could attempt to replay the prepared transaction(s) twice, leading to a fatal error such as “lock is already held” in the startup process.
Related records (4)
- Same changePostgreSQL 15.4 · Avoid double replay of prepared transactions during crash recovery
- Same changePostgreSQL 14.9 · Avoid double replay of prepared transactions during crash recovery
- Same changePostgreSQL 12.16 · Avoid double replay of prepared transactions during crash recovery
- Same changePostgreSQL 11.21 · Avoid double replay of prepared transactions during crash recovery
Bug fixesFix possible failure while promoting a standby server, if archiving is enabled and two-phase transactions need to be recovered
Changes
Fix possible failure while promoting a standby server, if archiving is enabled and two-phase transactions need to be recovered (Julian Markwort) §
If any required two-phase transactions were logged in the most recent (partial) log segment, promotion would fail with an incorrect complaint about “requested WAL segment has already been removed”.
ImprovementsEnsure that a newly created, but still empty table is fsync'ed at the next checkpoint
Changes
Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint (Heikki Linnakangas) §
Without this, if there is an operating system crash causing the empty file to disappear, subsequent operations on the table might fail with “could not open file” errors.
Related records (4)
- Same changePostgreSQL 15.4 · Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint
- Same changePostgreSQL 14.9 · Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint
- Same changePostgreSQL 12.16 · Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint
- Same changePostgreSQL 11.21 · Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint
ImprovementsEnsure that creation of the init fork of an unlogged index is WAL-logged
Changes
Ensure that creation of the init fork of an unlogged index is WAL-logged (Heikki Linnakangas) §
While an unlogged index's main data fork is not WAL-logged, its init fork should be, to ensure that we have a consistent state to restore the index to after a crash. This step was missed if the init fork contains no data, which is a case not used by any standard index AM; but perhaps some extension behaves that way.
Related records (4)
- Same changePostgreSQL 15.4 · Ensure that creation of the init fork of an unlogged index is WAL-logged
- Same changePostgreSQL 14.9 · Ensure that creation of the init fork of an unlogged index is WAL-logged
- Same changePostgreSQL 12.16 · Ensure that creation of the init fork of an unlogged index is WAL-logged
- Same changePostgreSQL 11.21 · Ensure that creation of the init fork of an unlogged index is WAL-logged
Bug fixesFix missing reinitializations of delay-checkpoint-end flags
Changes
Fix missing reinitializations of delay-checkpoint-end flags (suyu.cmj) §
This could result in unnecessary delays of checkpoints, or in assertion failures in assert-enabled builds.
Bug fixesFix overly strict assertion in jsonpath code
Changes
Fix overly strict assertion in jsonpath code (David Rowley) §
This assertion failed if a query applied the .type() operator to a like_regex result. There was no bug in non-assert builds.
Related records (3)
ImprovementsAvoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction
Changes
Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction (Tom Lane) §
Related records (4)
- Same changePostgreSQL 15.4 · Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction
- Same changePostgreSQL 14.9 · Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction
- Same changePostgreSQL 12.16 · Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction
- Same changePostgreSQL 11.21 · Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction
Bug fixesFix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely
Changes
Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely (Alexander Lakhin, Tom Lane) §
An input string containing no alphabetic characters resulted in unpredictable output.
Related records (4)
- Same changePostgreSQL 15.4 · Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely
- Same changePostgreSQL 14.9 · Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely
- Same changePostgreSQL 12.16 · Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely
- Same changePostgreSQL 11.21 · Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely
ImprovementsTighten whitespace checks in contrib/hstore input
Changes
Tighten whitespace checks in contrib/hstore input (Evan Jones) §
In some cases, characters would be falsely recognized as whitespace and hence discarded.
Related records (4)
- Same changePostgreSQL 15.4 · Tighten whitespace checks in contrib/hstore input
- Same changePostgreSQL 14.9 · Tighten whitespace checks in contrib/hstore input
- Same changePostgreSQL 12.16 · Tighten whitespace checks in contrib/hstore input
- Same changePostgreSQL 11.21 · Tighten whitespace checks in contrib/hstore input
ImprovementsDisallow oversize input arrays with contrib/intarray's gist__int_ops index opclass
Changes
Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass (Ankit Kumar Pandey, Alexander Lakhin) §
Previously this code would report a NOTICE but press on anyway, creating an invalid index entry that presents a risk of crashes when the index is read.
Related records (4)
- Same changePostgreSQL 15.4 · Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass
- Same changePostgreSQL 14.9 · Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass
- Same changePostgreSQL 12.16 · Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass
- Same changePostgreSQL 11.21 · Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass
ImprovementsAvoid useless double decompression of GiST index entries in contrib/intarray
Changes
Avoid useless double decompression of GiST index entries in contrib/intarray (Konstantin Knizhnik, Matthias van de Meent, Tom Lane) §
Related records (4)
- Same changePostgreSQL 15.4 · Avoid useless double decompression of GiST index entries in contrib/intarray
- Same changePostgreSQL 14.9 · Avoid useless double decompression of GiST index entries in contrib/intarray
- Same changePostgreSQL 12.16 · Avoid useless double decompression of GiST index entries in contrib/intarray
- Same changePostgreSQL 11.21 · Avoid useless double decompression of GiST index entries in contrib/intarray
ImprovementsEnsure that pg_index.indisreplident is kept up-to-date in relation cache entries
Changes
Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries (Shruthi Gowda) §
This value could be stale in some cases. There is no core code that relies on the relation cache's copy, so this is only a latent bug as far as Postgres itself is concerned; but there may be extensions for which it is a live bug.
Related records (4)
- Same changePostgreSQL 15.4 · Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries
- Same changePostgreSQL 14.9 · Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries
- Same changePostgreSQL 12.16 · Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries
- Same changePostgreSQL 11.21 · Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries
ImprovementsSilence deprecation warnings when compiling with OpenSSL 3.0.0 or later
Changes
Silence deprecation warnings when compiling with OpenSSL 3.0.0 or later (Peter Eisentraut) §
No matching changes
Try another search, or .
How is this comparison generated?
The comparison follows PostgreSQL release notes from just after the source through the target version. Confirmed backport duplicates are merged conservatively, with every original explanation retained. Related commits can represent independent changes; they remain separate records.
Release snapshot: 2026-11-19 · Security snapshot: 2026-09-26
Content comes from PostgreSQL release notes. Interaction inspired by pgversions.com and pgversionreport.