Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q0maO-0004ah-FO for pgsql-hackers@arkaria.postgresql.org; Sun, 21 May 2023 17:11:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q0maN-0007rL-E1 for pgsql-hackers@arkaria.postgresql.org; Sun, 21 May 2023 17:11:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q0maN-0007rC-0Q for pgsql-hackers@lists.postgresql.org; Sun, 21 May 2023 17:11:11 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q0maJ-0013IF-Q1 for pgsql-hackers@postgresql.org; Sun, 21 May 2023 17:11:09 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 34LHB5QJ277017; Sun, 21 May 2023 13:11:05 -0400 From: Tom Lane To: Bruce Momjian cc: Ian Lawrence Barwick , PostgreSQL-development Subject: Re: PG 16 draft release notes ready In-reply-to: References: Comments: In-reply-to Bruce Momjian message dated "Sun, 21 May 2023 11:52:34 -0400" MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----- =_aaaaaaaaaa0" Content-ID: <276901.1684689040.0@sss.pgh.pa.us> Date: Sun, 21 May 2023 13:11:05 -0400 Message-ID: <277016.1684689065@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------- =_aaaaaaaaaa0 Content-Type: text/plain; charset="us-ascii" Content-ID: <276901.1684689040.1@sss.pgh.pa.us> Bruce Momjian writes: > On Sun, May 21, 2023 at 09:30:01PM +0900, Ian Lawrence Barwick wrote: >> 2ceea5adb Accept "+infinity" in date and timestamp[tz] input. > I have this but didn't add that commit, added. That's really not related to the commit you added it to... I don't have time today to read through all the relnotes, but I went through those that have my name on them. Suggested wording modifications attached. regards, tom lane ------- =_aaaaaaaaaa0 Content-Type: text/x-diff; name="release-16-notes.patch"; charset="us-ascii" Content-ID: <276901.1684689040.2@sss.pgh.pa.us> Content-Description: release-16-notes.patch Content-Transfer-Encoding: quoted-printable diff --git a/doc/src/sgml/release-16.sgml b/doc/src/sgml/release-16.sgml index e156284b71..b31e31fccd 100644 --- a/doc/src/sgml/release-16.sgml +++ b/doc/src/sgml/release-16.sgml @@ -60,6 +60,8 @@ Change assignment rules for PL/pgSQL bound cursor variab= les (Tom Lane) = Previously, the string value of such variables was set to match the varia= ble name during cursor assignment; now it will be assigned during OPEN, a= nd will not match the variable name. +To restore the previous behavior, assign the desired portal name to the c= ursor +variable before OPEN. = @@ -257,7 +259,7 @@ Author: Tom Lane = -Allow memoize atop of UNION ALL and partitions (Richard Guo) +Allow memoize atop a UNION ALL (Richard Guo) = @@ -268,7 +270,8 @@ Author: Tom Lane = -Allow anti-joins to be constructed on the right/outer side (Richard Guo) +Allow anti-joins to be performed with the non-nullable input as the +inner relation (Richard Guo) = @@ -924,7 +927,7 @@ Allow makeaclitem() to accept multiple privilege names= (Robins Tharakan) = -Previously only a single privilege names, like SELECT, were supported. +Previously only a single privilege name, like SELECT, was accepted. = @@ -972,11 +975,7 @@ Author: Tom Lane = -Store server variables in a hash table (Tom Lane) - - - -This allows the faster addition of server variables. +Improve performance of server variable management (Tom Lane) = @@ -1081,7 +1080,9 @@ Allow the postmaster to terminate children with an a= bort signal (Tom Lane) = -Abort normally creates a core dump. This is controlled by send_abort_for= _crash and send_abort_for_kill. postmaster -T is now the same as setting = send_abort_for_crash. +This allows collection of a core dump for a stuck child process. +This is controlled by send_abort_for_crash and send_abort_for_kill. +The postmaster's -T switch is now the same as setting send_abort_for_cras= h. = @@ -1092,7 +1093,7 @@ Author: Tom Lane = -Remove the unnecessary postmaster -n option (Tom Lane) +Remove the non-functional postmaster -n option (Tom Lane) = @@ -1462,7 +1463,8 @@ Author: Tom Lane = -Add EXPLAIN option GENERIC_PLAN to display the query's generic plan (Laur= enz Albe) +Add EXPLAIN option GENERIC_PLAN to display the generic plan +for a parameterized query (Laurenz Albe) = @@ -1542,7 +1544,7 @@ Author: Tom Lane = -Add VACUUM option to skip or update all frozen statistics (Tom Lane, Nath= an Bossart) +Add VACUUM options to skip or update all frozen statistics (Tom Lane, Nat= han Bossart) = @@ -1635,13 +1637,23 @@ This can improve readability for long strings of d= igits. + + + +Accept the spelling "+infinity" in datetime input (Vik Fearing) + + + + = -Prevent the specification of "epoch" and "infinity" with other units in d= atetime strings (Joseph Koshakow) +Prevent the specification of "epoch" and "infinity" together with other f= ields +in datetime strings (Joseph Koshakow) = @@ -1652,7 +1664,9 @@ Author: Tom Lane = -Remove support for datetime input that prefixes year-month-day by Y/M/D (= Joseph Koshakow) +Remove undocumented support for date input in the form +"YyearMmonthDday" +(Joseph Koshakow) = @@ -1909,7 +1923,7 @@ Author: Tom Lane = -Allow to_reg* functions to accept OIDs parameters (Tom Lane) +Allow to_reg* functions to accept numeric OIDs as input (Tom Lane) = @@ -2024,7 +2038,8 @@ Author: Tom Lane = -Allow ECPG variable declarations to use type names which match SQL keywor= ds (Tom Lane) +Allow ECPG variable declarations to use typedef names that match unreserv= ed +SQL keywords (Tom Lane) = @@ -2130,7 +2145,8 @@ Author: Tom Lane = -Allow psql to detect the exit status of shell commands and queries (Corey= Huinker, Tom Lane) +Allow psql scripts to obtain the exit status of shell commands and querie= s +(Corey Huinker, Tom Lane) = @@ -2558,7 +2574,12 @@ Author: Andres Freund = -Prevent extension libraries from export their symbols by default (Andres = Freund, Tom Lane) +Prevent extension libraries from exporting their symbols by default (Andr= es Freund, Tom Lane) + + + +Functions that need to be called from the core backend or other extension= s +must now be explicitly marked PGDLLEXPORT. = @@ -2980,7 +3001,8 @@ Author: Tom Lane = -Allow the schemas of dependent extensions to be referenced using the new = syntax @extschema:dependent_extension_name@ (Regina Obe) +Allow the schemas of required extensions to be referenced in extension sc= ripts +using the new syntax @extschema:referenced_extension_name@ (Regina Obe) = @@ -2991,11 +3013,11 @@ Author: Tom Lane = -Allow dependent extensions to marked as non-relocatable using "no_relocat= e" (Regina Obe) +Allow required extensions to marked as non-relocatable using "no_relocate= " (Regina Obe) = -This allows @extschema:dependent_extension_name@ to be treated as a const= ant for the lifetime of the extension. +This allows @extschema:referenced_extension_name@ to be treated as a cons= tant for the lifetime of the extension. = ------- =_aaaaaaaaaa0--