<?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.5. Release 11.1</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="release-11-2.html" title="E.4. Release 11.2" /><link rel="next" href="release-11.html" title="E.6. Release 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.5. Release 11.1</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="release-11-2.html" title="E.4. Release 11.2">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 11.5 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="release-11.html" title="E.6. Release 11">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="RELEASE-11-1"><div class="titlepage"><div><div><h2 class="title" style="clear: both">E.5. Release 11.1</h2></div></div></div><div class="toc"><dl class="toc"><dt><span class="sect2"><a href="release-11-1.html#id-1.11.6.9.4">E.5.1. Migration to Version 11.1</a></span></dt><dt><span class="sect2"><a href="release-11-1.html#id-1.11.6.9.5">E.5.2. Changes</a></span></dt></dl></div><p><strong>Release date: </strong>2018-11-08</p><p> This release contains a variety of fixes from 11.0. For information about new features in major release 11, see <a class="xref" href="release-11.html" title="E.6. Release 11">Section E.6</a>. </p><div class="sect2" id="id-1.11.6.9.4"><div class="titlepage"><div><div><h3 class="title">E.5.1. Migration to Version 11.1</h3></div></div></div><p> A dump/restore is not required for those running 11.X. </p><p> However, if you use the <code class="filename">pg_stat_statements</code> extension, see the changelog entry below about that. </p></div><div class="sect2" id="id-1.11.6.9.5"><div class="titlepage"><div><div><h3 class="title">E.5.2. Changes</h3></div></div></div><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p> Ensure proper quoting of transition table names when <span class="application">pg_dump</span> emits <code class="command">CREATE TRIGGER ... REFERENCING</code> commands (Tom Lane) </p><p> This oversight could be exploited by an unprivileged user to gain superuser privileges during the next dump/reload or <span class="application">pg_upgrade</span> run. (CVE-2018-16850) </p></li><li class="listitem"><p> Apply the tablespace specified for a partitioned index when creating a child index (Álvaro Herrera) </p><p> Previously, child indexes were always created in the default tablespace. </p></li><li class="listitem"><p> Fix NULL handling in parallel hashed multi-batch left joins (Andrew Gierth, Thomas Munro) </p><p> Outer-relation rows with null values of the hash key were omitted from the join result. </p></li><li class="listitem"><p> Fix incorrect processing of an array-type coercion expression appearing within a <code class="literal">CASE</code> clause that has a constant test expression (Tom Lane) </p></li><li class="listitem"><p> Fix incorrect expansion of tuples lacking recently-added columns (Andrew Dunstan, Amit Langote) </p><p> This is known to lead to crashes in triggers on tables with recently-added columns, and could have other symptoms as well. </p></li><li class="listitem"><p> Fix bugs with named or defaulted arguments in <code class="command">CALL</code> argument lists (Tom Lane, Pavel Stehule) </p></li><li class="listitem"><p> Fix strictness check for strict aggregates with <code class="literal">ORDER BY</code> columns (Andrew Gierth, Andres Freund) </p><p> The strictness logic incorrectly ignored rows for which the <code class="literal">ORDER BY</code> value(s) were null. </p></li><li class="listitem"><p> Disable <code class="varname">recheck_on_update</code> optimization (Tom Lane) </p><p> This new-in-v11 feature turns out not to have been ready for prime time. Disable it until something can be done about it. </p></li><li class="listitem"><p> Prevent creation of a partition in a trigger attached to its parent table (Amit Langote) </p><p> Ideally we'd allow that, but for the moment it has to be blocked to avoid crashes. </p></li><li class="listitem"><p> Fix problems with applying <code class="literal">ON COMMIT DELETE ROWS</code> to a partitioned temporary table (Amit Langote) </p></li><li class="listitem"><p> Fix character-class checks to not fail on Windows for Unicode characters above U+FFFF (Tom Lane, Kenji Uno) </p><p> This bug affected full-text-search operations, as well as <code class="filename">contrib/ltree</code> and <code class="filename">contrib/pg_trgm</code>. </p></li><li class="listitem"><p> Ensure that the server will process already-received <code class="literal">NOTIFY</code> and <code class="literal">SIGTERM</code> interrupts before waiting for client input (Jeff Janes, Tom Lane) </p></li><li class="listitem"><p> Fix memory leak in repeated SP-GiST index scans (Tom Lane) </p><p> This is only known to amount to anything significant in cases where an exclusion constraint using SP-GiST receives many new index entries in a single command. </p></li><li class="listitem"><p> Prevent starting the server with <code class="varname">wal_level</code> set to too low a value to support an existing replication slot (Andres Freund) </p></li><li class="listitem"><p> Fix <span class="application">psql</span>, as well as documentation examples, to call <code class="function">PQconsumeInput()</code> before each <code class="function">PQnotifies()</code> call (Tom Lane) </p><p> This fixes cases in which <span class="application">psql</span> would not report receipt of a <code class="literal">NOTIFY</code> message until after the next command. </p></li><li class="listitem"><p> Fix <span class="application">pg_verify_checksums</span>'s determination of which files to check the checksums of (Michael Paquier) </p><p> In some cases it complained about files that are not expected to have checksums. </p></li><li class="listitem"><p> In <code class="filename">contrib/pg_stat_statements</code>, disallow the <code class="literal">pg_read_all_stats</code> role from executing <code class="function">pg_stat_statements_reset()</code> (Haribabu Kommi) </p><p> <code class="literal">pg_read_all_stats</code> is only meant to grant permission to read statistics, not to change them, so this grant was incorrect. </p><p> To cause this change to take effect, run <code class="literal">ALTER EXTENSION pg_stat_statements UPDATE</code> in each database where <code class="filename">pg_stat_statements</code> has been installed. (A database freshly created in 11.0 should not need this, but a database upgraded from a previous release probably still contains the old version of <code class="filename">pg_stat_statements</code>. The <code class="literal">UPDATE</code> command is harmless if the module was already updated.) </p></li><li class="listitem"><p> Rename red-black tree support functions to use <code class="literal">rbt</code> prefix not <code class="literal">rb</code> prefix (Tom Lane) </p><p> This avoids name collisions with Ruby functions, which broke PL/Ruby. It's hoped that there are no other affected extensions. </p></li><li class="listitem"><p> Fix build problems on macOS 10.14 (Mojave) (Tom Lane) </p><p> Adjust <span class="application">configure</span> to add an <code class="option">-isysroot</code> switch to <code class="varname">CPPFLAGS</code>; without this, PL/Perl and PL/Tcl fail to configure or build on macOS 10.14. The specific sysroot used can be overridden at configure time or build time by setting the <code class="varname">PG_SYSROOT</code> variable in the arguments of <span class="application">configure</span> or <span class="application">make</span>. </p><p> It is now recommended that Perl-related extensions write <code class="literal">$(perl_includespec)</code> rather than <code class="literal">-I$(perl_archlibexp)/CORE</code> in their compiler flags. The latter continues to work on most platforms, but not recent macOS. </p><p> Also, it should no longer be necessary to specify <code class="option">--with-tclconfig</code> manually to get PL/Tcl to build on recent macOS releases. </p></li><li class="listitem"><p> Fix MSVC build and regression-test scripts to work on recent Perl versions (Andrew Dunstan) </p><p> Perl no longer includes the current directory in its search path by default; work around that. </p></li><li class="listitem"><p> On Windows, allow the regression tests to be run by an Administrator account (Andrew Dunstan) </p><p> To do this safely, <span class="application">pg_regress</span> now gives up any such privileges at startup. </p></li><li class="listitem"><p> Update time zone data files to <span class="application">tzdata</span> release 2018g for DST law changes in Chile, Fiji, Morocco, and Russia (Volgograd), plus historical corrections for China, Hawaii, Japan, Macau, and North Korea. </p></li></ul></div></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="release-11-2.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="release.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="release-11.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">E.4. Release 11.2 </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> E.6. Release 11</td></tr></table></div></body></html>