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 <[email protected]>
> 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 <[email protected]>
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 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 <[email protected]>
+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 <[email protected]>
2026-04-08 [77645d44e] Remove MULE_INTERNAL encoding.
@@ -1690,18 +1702,6 @@ This allows operations on temporal ranges.
</para>
</listitem>
-<!--
-Author: Tom Lane <[email protected]>
-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 <[email protected]>
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 <[email protected]>
+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 <[email protected]>
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 <[email protected]>
-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>
