Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wlFjh-000471-0H for pgsql-hackers@arkaria.postgresql.org; Sun, 19 Jul 2026 00:50:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wlFjg-000MxJ-1z for pgsql-hackers@arkaria.postgresql.org; Sun, 19 Jul 2026 00:50:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wlFjg-000MxB-0t for pgsql-hackers@lists.postgresql.org; Sun, 19 Jul 2026 00:50:27 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wlFjd-00000000trc-0nQ8 for pgsql-hackers@lists.postgresql.org; Sun, 19 Jul 2026 00:50:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2026010100; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=3iYjDW+gmATwkeNRyPaaZw/rUvp03ADl9S/UQzdRzNY=; b=uyMjaSJUVd3fYkCmzBWHDICUHP FiwIozu5ugrsLwFevwCfnewmPTwn+iLA+Omtv/5dgOYibPGGUYlauiLL9ACAVLPw9RAP79un/9YhP 8rdpPfkhFy245j8e1iRu7rp3av0NLBIxk7jwx0ejsuDO2SKq2wwpcDnSYU4vAxFsgDEUmH5fq1X8G XyVv2pL2pEpXsWKluUkYEsvFdiyGIKd5qHbvdcMiYTFhK76RRi+RTjwiZOQquM83VGBlay04D2naK S8rT35P4rh8kbvma/VQXepRdEvpyPxNk3BAYJwNQrWxPC3zwY/dhS2KaSLMlIjXlDeHPsCN21z/ur 0STUqqzw==; Received: from bruce by momjian.us with local (Exim 4.98.2) (envelope-from ) id 1wlFjc-0000000DuQa-2SUt; Sat, 18 Jul 2026 20:50:24 -0400 Date: Sat, 18 Jul 2026 20:50:24 -0400 From: Bruce Momjian To: Chao Li Cc: PostgreSQL-development Subject: Re: First draft of PG 19 release notes Message-ID: References: <061be328-b319-402a-b2a2-cdb99f85b2c1@proxel.se> <2587B36C-6233-4DC4-8A2D-1F96BE9B2BAB@gmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="5gY+nksD46PvL6/Q" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <2587B36C-6233-4DC4-8A2D-1F96BE9B2BAB@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --5gY+nksD46PvL6/Q Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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. > > 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 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 https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future. --5gY+nksD46PvL6/Q Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="REL_19_STABLE.diff" Content-Transfer-Encoding: 8bit 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 @@ Release date: - 2026-??-??, AS OF 2026-06-17 + 2026-??-??, AS OF 2026-07-18 @@ -307,6 +307,18 @@ Remove optimizer hook get_relation_info_hook and add better-placed hook build_si + + + + +Change psql's \crosstabview command to honor the \pset null setting (Chao Li) +§ + + + - - - -Add GROUP BY ALL syntax to SELECT to automatically group all non-aggregate and non-window-function target list parameters (David Christensen) -§ - - - + + + +Allow pg_dump to include restorable extended statistics (Corey Huinker) +§ + + + - - - -Allow pg_dump to include restorable extended statistics (Corey Huinker) -§ - - - <link linkend="app-pgcreatesubscriber"><application>pg_createsubscriber</application></link> --5gY+nksD46PvL6/Q--