From: Bruce Momjian <bruce@momjian.us>
To: Chao Li <li.evan.chao@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Subject: Re: First draft of PG 19 release notes
Date: Sat, 18 Jul 2026 20:50:24 -0400
Message-ID: <alwfUMjJ8NADFEF9@momjian.us> (raw)
In-Reply-To: <2587B36C-6233-4DC4-8A2D-1F96BE9B2BAB@gmail.com>
References: <ad7ngXC125AvNqC2@momjian.us>
<061be328-b319-402a-b2a2-cdb99f85b2c1@proxel.se>
<f5f129c3-88fa-43dc-a23a-75155fa10be3@proxel.se>
<aldZNzNrPK4TpU-8@momjian.us>
<algBwcaq2SqHY_O_@momjian.us>
<CAOYmi+k5h_w5p6HsVJF5k+bNGmChMAhpGU_1gjJMxHg080XibA@mail.gmail.com>
<alqKzNOyCYBAu0DS@momjian.us>
<2587B36C-6233-4DC4-8A2D-1F96BE9B2BAB@gmail.com>
On Sat, Jul 18, 2026 at 06:03:09AM +0800, Chao Li wrote:
> Hi Bruce,
>
> This feature has been reverted by 372b8d1adb76740123791e9ded4f665b175f5bf5, so you need to delete the item from the v19 release note.
>
> <!--
> Author: Tom Lane <tgl@sss.pgh.pa.us>
> 2025-09-29 [ef38a4d97] Add GROUP BY ALL.
> -->
I have updated the release notes to match current git; updated output
is at:
https://momjian.us/pgsql_docs/
Patch attached. I added the psql \crosstabview item as an
incompatibility. I didn't add this commit:
commit 0c15b715c65
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Tue Jun 30 17:21:23 2026 -0400
Disallow set-returning functions within window OVER clauses.
We previously allowed this, but it leads to odd behaviors, basically
because putting a SRF there is inconsistent with the principle that a
window function doesn't change the number of rows in the query result.
There doesn't seem to be a strong reason to try to make such cases
behave consistently. Users should put their SRFs in lateral FROM
clauses instead.
This issue has been sitting on the back burner for multiple years
now, partially because it didn't seem wise to back-patch such a
change. Let's squeeze it into v19 before it's too late.
because I assumed its use was rare enough and the error message clear
enough.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
Attachments:
[text/x-diff] REL_19_STABLE.diff (3.5K, ../alwfUMjJ8NADFEF9@momjian.us/2-REL_19_STABLE.diff)
download | inline diff:diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex 75f0ea04fda..7e93f7a8b95 100644--- a/doc/src/sgml/release-19.sgml+++ b/doc/src/sgml/release-19.sgml@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2026-??-??, AS OF 2026-06-17</para>+ <para>2026-??-??, AS OF 2026-07-18</para>
</formalpara>
<sect2 id="release-19-highlights">
@@ -307,6 +307,18 @@ Remove optimizer hook get_relation_info_hook and add better-placed hook build_si
</para>
</listitem>
+<!--+Author: Álvaro Herrera <alvherre@kurilemu.de>+2026-06-26 [4df5fe383] 2026-06-26 Make crosstabview honor boolean/null display+-->++<listitem>+<para>+Change <link linkend="app-psql"><application>psql</application></link>'s <literal>\crosstabview</literal> command to honor the <literal>\pset null</literal> setting (Chao Li)+<ulink url="&commit_baseurl;4df5fe383">§</ulink>+</para>+</listitem>+
<!--
Author: Thomas Munro <tmunro@postgresql.org>
2026-04-08 [77645d44e] Remove MULE_INTERNAL encoding.
@@ -1690,18 +1702,6 @@ This allows operations on temporal ranges.
</para>
</listitem>
-<!---Author: Tom Lane <tgl@sss.pgh.pa.us>-2025-09-29 [ef38a4d97] Add GROUP BY ALL.--->--<listitem>-<para>-Add <literal>GROUP BY ALL</literal> syntax to <link linkend="sql-select"><command>SELECT</command></link> to automatically group all non-aggregate and non-window-function target list parameters (David Christensen)-<ulink url="&commit_baseurl;ef38a4d97">§</ulink>-</para>-</listitem>-
<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2026-03-06 [415100aa6] Support grouping-expression references and GROUPING() in
@@ -2536,6 +2536,18 @@ Add or improve <link linkend="app-psql"><application>psql</application></link> t
<title>Server Applications</title>
<itemizedlist>
+<!--+Author: Michael Paquier <michael@paquier.xyz>+2026-01-27 [c32fb29e9] Include extended statistics data in pg_dump+-->++<listitem>+<para>+Allow <link linkend="app-pgdump"><application>pg_dump</application></link> to include restorable extended statistics (Corey Huinker)+<ulink url="&commit_baseurl;c32fb29e9">§</ulink>+</para>+</listitem>+
<!--
Author: Fujii Masao <fujii@postgresql.org>
2025-08-20 [6429e5b77] vacuumdb: Make vacuumdb - -analyze-only process partition
@@ -2665,33 +2677,10 @@ Improve the usability of <link linkend="pgtesttiming"><application>pg_test_timin
<para>
Report nanoseconds instead of microseconds. In addition to histogram output, output a second table that reports exact timings, with an optional cutoff set by <option>--cutoff</option>.
</para>
-</listitem>-- </itemizedlist>-- <sect4 id="release-19-pgdump">- <title><link- linkend="app-pgdump"><application>pg_dump</application></link>/<link- linkend="app-pg-dumpall"><application>pg_dumpall</application></link>/<link- linkend="app-pgrestore"><application>pg_restore</application></link></title>-- <itemizedlist>-<!---Author: Michael Paquier <michael@paquier.xyz>-2026-01-27 [c32fb29e9] Include extended statistics data in pg_dump--->--<listitem>-<para>-Allow <link linkend="app-pgdump"><application>pg_dump</application></link> to include restorable extended statistics (Corey Huinker)-<ulink url="&commit_baseurl;c32fb29e9">§</ulink>-</para>
</listitem>
</itemizedlist>
- </sect4>-
<sect4 id="release-19-pg-createsubscriber">
<title><link linkend="app-pgcreatesubscriber"><application>pg_createsubscriber</application></link></title>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: bruce@momjian.us, li.evan.chao@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: First draft of PG 19 release notes
In-Reply-To: <alwfUMjJ8NADFEF9@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox