| Server IP : 172.67.134.114 / Your IP : 162.159.115.41 Web Server : Apache/2.4.37 System : Linux almalinux.duckdns.org 4.18.0-553.111.1.el8_10.x86_64 #1 SMP Sun Mar 8 20:06:07 EDT 2026 x86_64 User : ricodeal ( 1046) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/postgresql-docs/html/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>E.12. Release 10.12</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="[email protected]" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="release-10-13.html" title="E.11. Release 10.13" /><link rel="next" href="release-10-11.html" title="E.13. Release 10.11" /></head><body><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">E.12. Release 10.12</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="release-10-13.html" title="E.11. Release 10.13">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="release.html" title="Appendix E. Release Notes">Up</a></td><th width="60%" align="center">Appendix E. Release Notes</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 10.23 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="release-10-11.html" title="E.13. Release 10.11">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="RELEASE-10-12"><div class="titlepage"><div><div><h2 class="title" style="clear: both">E.12. Release 10.12</h2></div></div></div><div class="toc"><dl class="toc"><dt><span class="sect2"><a href="release-10-12.html#id-1.11.6.16.4">E.12.1. Migration to Version 10.12</a></span></dt><dt><span class="sect2"><a href="release-10-12.html#id-1.11.6.16.5">E.12.2. Changes</a></span></dt></dl></div><p><strong>Release date: </strong>2020-02-13</p><p> This release contains a variety of fixes from 10.11.
For information about new features in major release 10, see
<a class="xref" href="release-10.html" title="E.24. Release 10">Section E.24</a>.
</p><div class="sect2" id="id-1.11.6.16.4"><div class="titlepage"><div><div><h3 class="title">E.12.1. Migration to Version 10.12</h3></div></div></div><p> A dump/restore is not required for those running 10.X.
</p><p> However, if you are upgrading from a version earlier than 10.11,
see <a class="xref" href="release-10-11.html" title="E.13. Release 10.11">Section E.13</a>.
</p></div><div class="sect2" id="id-1.11.6.16.5"><div class="titlepage"><div><div><h3 class="title">E.12.2. Changes</h3></div></div></div><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p> Add missing permissions checks for <code class="command">ALTER ... DEPENDS ON
EXTENSION</code> (Álvaro Herrera)
</p><p> Marking an object as dependent on an extension did not have any
privilege check whatsoever. This oversight allowed any user to mark
routines, triggers, materialized views, or indexes as droppable by
anyone able to drop an extension. Require that the calling user own
the specified object (and hence have privilege to drop it).
(CVE-2020-1720)
</p></li><li class="listitem"><p> Fix logical replication subscriber code to execute
per-column <code class="literal">UPDATE</code> triggers when appropriate
(Peter Eisentraut)
</p></li><li class="listitem"><p> Avoid failure in logical decoding when a large transaction must be
spilled into many separate temporary files (Amit Khandekar)
</p></li><li class="listitem"><p> Fix possible crash or data corruption when a logical replication
subscriber processes a row update (Tom Lane, Tomas Vondra)
</p><p> This bug caused visible problems only if the subscriber's table
contained columns that were not being copied from the publisher and
had pass-by-reference data types.
</p></li><li class="listitem"><p> Fix crash in logical replication subscriber after DDL changes on a
subscribed relation (Jehan-Guillaume de Rorthais, Vignesh C)
</p></li><li class="listitem"><p> Fix failure in logical replication publisher after a database crash
and restart (Vignesh C)
</p></li><li class="listitem"><p> Improve efficiency of logical replication with <code class="literal">REPLICA
IDENTITY FULL</code> (Konstantin Knizhnik)
</p><p> When searching for an existing tuple during an update or delete
operation, return the first matching tuple not the last one.
</p></li><li class="listitem"><p> Prevent premature shutdown of a Gather or GatherMerge plan node that
is underneath a Limit node (Amit Kapila)
</p><p> This avoids failure if such a plan node needs to be scanned more
than once, as for instance if it is on the inside of a nestloop.
</p></li><li class="listitem"><p> Avoid memory leak when there are no free dynamic shared memory slots
(Thomas Munro)
</p></li><li class="listitem"><p> Ignore the <code class="literal">CONCURRENTLY</code> option when performing an
index creation, drop, or rebuild on a temporary table (Michael
Paquier, Heikki Linnakangas, Andres Freund)
</p><p> This avoids strange failures if the temporary table has
an <code class="literal">ON COMMIT</code> action. There is no benefit in
using <code class="literal">CONCURRENTLY</code> for a temporary table anyway,
since other sessions cannot access the table, making the extra
processing pointless.
</p></li><li class="listitem"><p> Fix possible failure when resetting expression indexes on temporary
tables that are marked <code class="literal">ON COMMIT DELETE ROWS</code>
(Tom Lane)
</p></li><li class="listitem"><p> Fix possible crash in BRIN index operations
with <code class="type">box</code>, <code class="type">range</code> and <code class="type">inet</code> data
types (Heikki Linnakangas)
</p></li><li class="listitem"><p> Fix handling of deleted pages in GIN indexes (Alexander Korotkov)
</p><p> Avoid possible deadlocks, incorrect updates of a deleted page's
state, and failure to traverse through a recently-deleted page.
</p></li><li class="listitem"><p> Fix possible crash with a SubPlan (sub-<code class="literal">SELECT</code>)
within a multi-row <code class="literal">VALUES</code> list (Tom Lane)
</p></li><li class="listitem"><p> Fix crash after FileClose() failure (Noah Misch)
</p><p> This issue could only be observed
with <code class="varname">data_sync_retry</code> enabled, since otherwise
FileClose() failure would be reported as a PANIC.
</p></li><li class="listitem"><p> Fix unlikely crash with pass-by-reference aggregate transition
states (Andres Freund, Teodor Sigaev)
</p></li><li class="listitem"><p> Improve error reporting in <code class="function">to_date()</code>
and <code class="function">to_timestamp()</code>
(Tom Lane, Álvaro Herrera)
</p><p> Reports about incorrect month or day names in input strings could
truncate the input in the middle of a multi-byte character, leading
to an improperly encoded error message that could cause follow-on
failures. Truncate at the next whitespace instead.
</p></li><li class="listitem"><p> Fix off-by-one result for <code class="literal">EXTRACT(ISOYEAR
FROM <em class="replaceable"><code>timestamp</code></em>)</code> for BC dates
(Tom Lane)
</p></li><li class="listitem"><p> Avoid stack overflow in <code class="literal">information_schema</code> views
when a self-referential view exists in the system catalogs
(Tom Lane)
</p><p> A self-referential view can't work; it will always result in
infinite recursion. We handled that situation correctly when
trying to execute the view, but not when inquiring whether it is
automatically updatable.
</p></li><li class="listitem"><p> Ensure that walsender processes always show NULL for transaction
start time in <code class="structname">pg_stat_activity</code>
(Álvaro Herrera)
</p><p> Previously, the <code class="structfield">xact_start</code> column would
sometimes show the process start time.
</p></li><li class="listitem"><p> Improve performance of hash joins with very large inner relations
(Thomas Munro)
</p></li><li class="listitem"><p> Fix edge-case crashes and misestimations in selectivity calculations
for the <code class="literal"><@</code> and <code class="literal">@></code> range
operators (Michael Paquier, Andrey Borodin, Tom Lane)
</p></li><li class="listitem"><p> Ignore system columns when applying most-common-value
extended statistics (Tomas Vondra)
</p><p> This prevents <span class="quote">“<span class="quote">negative bitmapset member not allowed</span>”</span>
planner errors for affected queries.
</p></li><li class="listitem"><p> Fix BRIN index logic to support hypothetical BRIN indexes
(Julien Rouhaud, Heikki Linnakangas)
</p><p> Previously, if an <span class="quote">“<span class="quote">index adviser</span>”</span> extension tried to
get the planner to produce a plan involving a hypothetical BRIN
index, that would fail, because the BRIN cost estimation code would
always try to physically access the index's metapage. Now it checks
to see if the index is only hypothetical, and uses default
assumptions about the index parameters if so.
</p></li><li class="listitem"><p> Improve error reporting for attempts to use automatic updating of
views with conditional <code class="literal">INSTEAD</code> rules (Dean Rasheed)
</p><p> This has never been supported, but previously the error was thrown
only at execution time, so that it could be masked by planner errors.
</p></li><li class="listitem"><p> Prevent a composite type from being included in itself indirectly
via a range type (Tom Lane, Julien Rouhaud)
</p></li><li class="listitem"><p> Disallow partition key expressions that return pseudo-types, such
as <code class="type">record</code> (Tom Lane)
</p></li><li class="listitem"><p> Fix error reporting for index expressions of prohibited types
(Amit Langote)
</p></li><li class="listitem"><p> Fix dumping of views that contain only a <code class="literal">VALUES</code>
list to handle cases where a view output column has been renamed
(Tom Lane)
</p></li><li class="listitem"><p> Ensure that data types and collations used
in <code class="literal">XMLTABLE</code> constructs are accounted for when
computing dependencies of a view or rule (Tom Lane)
</p><p> Previously it was possible to break a view
using <code class="literal">XMLTABLE</code> by dropping a type, if the type
was not otherwise referenced in the view. This fix does not
correct the dependencies already recorded for existing views, only
for newly-created ones.
</p></li><li class="listitem"><p> Prevent unwanted downcasing and truncation of RADIUS authentication
parameters (Marcos David)
</p><p> The <code class="filename">pg_hba.conf</code> parser mistakenly treated these
fields as SQL identifiers, which in general they aren't.
</p></li><li class="listitem"><p> Transmit incoming <code class="command">NOTIFY</code> messages to the client
before sending <code class="literal">ReadyForQuery</code>, rather than after
(Tom Lane)
</p><p> This change ensures that, with libpq and other client libraries that
act similarly to it, any notifications received during a transaction
will be available by the time the client thinks the transaction is
complete. This probably makes no difference in practical
applications (which would need to cope with asynchronous
notifications in any case); but it makes it easier to build test
cases with reproducible behavior.
</p></li><li class="listitem"><p> Allow <span class="application">libpq</span> to parse all GSS-related
connection parameters even when the GSSAPI code hasn't been compiled
in (Tom Lane)
</p><p> This makes the behavior similar to our SSL support, where it was
long ago deemed to be a good idea to always accept all the related
parameters, even if some are ignored or restricted due to lack of
the feature in a particular build.
</p></li><li class="listitem"><p> Fix incorrect handling of <code class="literal">%b</code>
and <code class="literal">%B</code> format codes
in <span class="application">ecpg</span>'s
<code class="function">PGTYPEStimestamp_fmt_asc()</code> function
(Tomas Vondra)
</p><p> Due to an off-by-one error, these codes would print the wrong month
name, or possibly crash.
</p></li><li class="listitem"><p> Fix
parallel <span class="application">pg_dump</span>/<span class="application">pg_restore</span>
to more gracefully handle failure to create worker processes
(Tom Lane)
</p></li><li class="listitem"><p> Prevent possible crash or lockup when attempting to terminate a
parallel <span class="application">pg_dump</span>/<span class="application">pg_restore</span>
run via a signal (Tom Lane)
</p></li><li class="listitem"><p> In <span class="application">pg_upgrade</span>, look inside arrays and
ranges while searching for non-upgradable data types in tables
(Tom Lane)
</p></li><li class="listitem"><p> Apply more thorough syntax checking
to <span class="application">createuser</span>'s
<code class="option">--connection-limit</code> option (Álvaro Herrera)
</p></li><li class="listitem"><p> Avoid crash in <code class="filename">postgres_fdw</code> when trying to
send a command like <code class="literal">UPDATE remote_tab SET (x,y) = (SELECT
...)</code> to the remote server (Tom Lane)
</p></li><li class="listitem"><p> In <code class="filename">contrib/dict_int</code>,
reject <code class="varname">maxlen</code> settings less than one
(Tomas Vondra)
</p><p> This prevents a possible crash with silly settings for that parameter.
</p></li><li class="listitem"><p> Disallow NULL category values
in <code class="filename">contrib/tablefunc</code>'s
<code class="function">crosstab()</code> function (Joe Conway)
</p><p> This case never worked usefully, and it would crash on some
platforms.
</p></li><li class="listitem"><p> Mark some timeout and statistics-tracking GUC variables
as <code class="literal">PGDLLIMPORT</code>, to allow extensions to access
them on Windows (Pascal Legrand)
</p><p> This applies to
<code class="literal">idle_in_transaction_session_timeout</code>,
<code class="literal">lock_timeout</code>,
<code class="literal">statement_timeout</code>,
<code class="literal">track_activities</code>,
<code class="literal">track_counts</code>, and
<code class="literal">track_functions</code>.
</p></li><li class="listitem"><p> Avoid memory leak in sanity checks for <span class="quote">“<span class="quote">slab</span>”</span> memory
contexts (Tomas Vondra)
</p><p> This isn't an issue for production builds, since they wouldn't
ordinarily have memory context checking enabled; but the leak could
be quite severe in a debug build.
</p></li><li class="listitem"><p> Fix multiple statistics entries reported by the LWLock statistics
mechanism (Fujii Masao)
</p><p> The LWLock statistics code (which is not built by default; it
requires compiling with <code class="option">-DLWLOCK_STATS</code>)
could report multiple entries for the same LWLock and backend
process, as a result of faulty hashtable key creation.
</p></li><li class="listitem"><p> Fix race condition that led to delayed delivery of interprocess
signals on Windows (Amit Kapila)
</p><p> This caused visible timing oddities in <code class="command">NOTIFY</code>,
and perhaps other misbehavior.
</p></li><li class="listitem"><p> On Windows, retry a few times after
an <code class="literal">ERROR_ACCESS_DENIED</code> file access failure
(Alexander Lakhin, Tom Lane)
</p><p> This helps cope with cases where a file open attempt fails because
the targeted file is flagged for deletion but not yet actually gone.
<span class="application">pg_ctl</span>, for example, frequently failed
with such an error when probing to see if the postmaster had shut
down yet.
</p></li></ul></div></div></div><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navfooter"><hr></hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="release-10-13.html" title="E.11. Release 10.13">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="release.html" title="Appendix E. Release Notes">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="release-10-11.html" title="E.13. Release 10.11">Next</a></td></tr><tr><td width="40%" align="left" valign="top">E.11. Release 10.13 </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 10.23 Documentation">Home</a></td><td width="40%" align="right" valign="top"> E.13. Release 10.11</td></tr></table></div></body></html>