Skip to content

Commit e956325

Browse files
tglsfdctglsfdc
committed
Doc: update v15 release notes through today.
Account for commits since 2022-06-11.
1 parent bd8ac90 commit e956325

File tree

1 file changed

+180
-43
lines changed

1 file changed

+180
-43
lines changed

‎doc/src/sgml/release-15.sgml

Lines changed: 180 additions & 43 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33

44
<formalpara>
55
<title>Release date:</title>
6-
<para>AS OF 2022-06-11</para>
6+
<para>AS OF 2022-09-23</para>
77
</formalpara>
88

99
<sect2>
@@ -252,20 +252,6 @@ Author: Peter Eisentraut <peter@eisentraut.org>
252252
</para>
253253
</listitem>
254254

255-
<!--
256-
Author: Tom Lane <tgl@sss.pgh.pa.us>
257-
2021-12-15 [2a712066d] Remove pg_dump's - -no-synchronized-snapshots switch.
258-
-->
259-
260-
<listitem>
261-
<para>
262-
Remove <link
263-
linkend="sql-syntax-identifiers"><application>pg_dump</application></link>'s
264-
<option>--no-synchronized-snapshots</option> option since all
265-
supported server versions support synchronized snapshots (Tom Lane)
266-
</para>
267-
</listitem>
268-
269255
<!--
270256
Author: Tom Lane <tgl@sss.pgh.pa.us>
271257
2022-02-15 [2523928b2] Reject change of output-column collation in CREATE OR RE
@@ -370,6 +356,23 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
370356
</para>
371357
</listitem>
372358

359+
<!--
360+
Author: Tom Lane <tgl@sss.pgh.pa.us>
361+
2022-08-02 [c034b629c] Change type "char"'s I/O format for non-ASCII characters
362+
-->
363+
364+
<listitem>
365+
<para>
366+
Change the I/O format of type <type>"char"</type> for non-ASCII
367+
characters (Tom Lane)
368+
</para>
369+
370+
<para>
371+
Bytes with the high bit set are now output as a backslash and three
372+
octal digits, to avoid encoding issues.
373+
</para>
374+
</listitem>
375+
373376
<!--
374377
Author: Robert Haas <rhaas@postgresql.org>
375378
2022-03-28 [79de9842a] Remove the ability of a role to administer itself.
@@ -443,24 +446,6 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
443446
</para>
444447
</listitem>
445448

446-
<!--
447-
Author: Tom Lane <tgl@sss.pgh.pa.us>
448-
2022-02-28 [2e517818f] Fix SPI's handling of errors during transaction commit.
449-
-->
450-
451-
<listitem>
452-
<para>
453-
Modify <link linkend="spi"><acronym>SPI</acronym></link>'s
454-
<function>SPI_commit()</function> and
455-
<function>SPI_commit_and_chain()</function> to automatically start
456-
a new transaction at completion (Peter Eisentraut, Tom Lane)
457-
</para>
458-
459-
<para>
460-
BACKPATCHED?
461-
</para>
462-
</listitem>
463-
464449
<!--
465450
Author: Tom Lane <tgl@sss.pgh.pa.us>
466451
2022-03-24 [ce95c5437] Fix pg_statio_all_tables view for multiple TOAST indexes
@@ -534,6 +519,40 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
534519
</para>
535520
</listitem>
536521

522+
<!--
523+
Author: Tom Lane <tgl@sss.pgh.pa.us>
524+
2021-12-15 [2a712066d] Remove pg_dump's - -no-synchronized-snapshots switch.
525+
-->
526+
527+
<listitem>
528+
<para>
529+
Remove <link
530+
linkend="app-pgdump"><application>pg_dump</application></link>'s
531+
<option>--no-synchronized-snapshots</option> option (Tom Lane)
532+
</para>
533+
534+
<para>
535+
All still-supported server versions support synchronized snapshots,
536+
so there's no longer a need for this option.
537+
</para>
538+
</listitem>
539+
540+
<!--
541+
Author: Michael Paquier <michael@paquier.xyz>
542+
2022-06-15 [a3ff08e0b] Tweak behavior of psql - -single-transaction depending
543+
-->
544+
545+
<listitem>
546+
<para>
547+
After an error is detected in <link
548+
linkend="app-psql"><application>psql</application></link>'s
549+
<option>--single-transaction</option> mode, change the
550+
final <command>COMMIT</command> command
551+
to <command>ROLLBACK</command> only
552+
if <varname>ON_ERROR_STOP</varname> is set (Michael Paquier)
553+
</para>
554+
</listitem>
555+
537556
<!--
538557
Author: Tom Lane <tgl@sss.pgh.pa.us>
539558
2021-11-12 [f8abb0f5e] postgres_fdw: suppress casts on constants in limited cas
@@ -1264,6 +1283,8 @@ Author: Robert Haas <rhaas@postgresql.org>
12641283
<!--
12651284
Author: Tom Lane <tgl@sss.pgh.pa.us>
12661285
2022-04-06 [a0ffa885e] Allow granting SET and ALTER SYSTEM privileges on GUC pa
1286+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1287+
2022-07-19 [a2944d872] Fix missed corner cases for grantable permissions on GUC
12671288
-->
12681289

12691290
<listitem>
@@ -1283,12 +1304,14 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
12831304
<!--
12841305
Author: Jeff Davis <jdavis@postgresql.org>
12851306
2021-11-09 [4168a4745] Add pg_checkpointer predefined role for CHECKPOINT comma
1307+
Author: Robert Haas <rhaas@postgresql.org>
1308+
2022-07-05 [d3526e59f] Rename pg_checkpointer predefined role to pg_checkpoint.
12861309
-->
12871310

12881311
<listitem>
12891312
<para>
12901313
Add predefined role <link
1291-
linkend="predefined-roles-table"><literal>pg_checkpointer</literal></link>
1314+
linkend="predefined-roles-table"><literal>pg_checkpoint</literal></link>
12921315
that allows members to run <command>CHECKPOINT</command>
12931316
(Jeff Davis)
12941317
</para>
@@ -1380,6 +1403,44 @@ Author: Michael Paquier <michael@paquier.xyz>
13801403
</para>
13811404
</listitem>
13821405

1406+
<!--
1407+
Author: Jeff Davis <jdavis@postgresql.org>
1408+
2022-07-20 [2103266a3] Process shared_preload_libraries in single-user mode.
1409+
-->
1410+
1411+
<listitem>
1412+
<para>
1413+
Honor server variable <link
1414+
linkend="guc-shared-preload-libraries"><varname>shared_preload_libraries</varname></link>
1415+
in single-user mode (Jeff Davis)
1416+
</para>
1417+
1418+
<para>
1419+
This change supports use
1420+
of <varname>shared_preload_libraries</varname> to load custom
1421+
access methods and WAL resource managers, which would be essential
1422+
for database access even in single-user mode.
1423+
</para>
1424+
</listitem>
1425+
1426+
<!--
1427+
Author: Thomas Munro <tmunro@postgresql.org>
1428+
2022-07-02 [a2b0719cc] Default to dynamic_shared_memory_type=sysv on Solaris.
1429+
-->
1430+
1431+
<listitem>
1432+
<para>
1433+
On Solaris, make the default setting of <link
1434+
linkend="guc-dynamic-shared-memory-type"><varname>dynamic_shared_memory_type</varname></link>
1435+
be <literal>sysv</literal> (Thomas Munro)
1436+
</para>
1437+
1438+
<para>
1439+
The previous default choice, <literal>posix</literal>, can result
1440+
in spurious failures on this platform.
1441+
</para>
1442+
</listitem>
1443+
13831444
<!--
13841445
Author: Michael Paquier <michael@paquier.xyz>
13851446
2021-09-16 [0c39c2920] Support "postgres -C" with runtime-computed GUCs
@@ -1502,6 +1563,8 @@ Author: Amit Kapila <akapila@postgresql.org>
15021563
2021-10-27 [5a2832465] Allow publishing the tables of schema.
15031564
Author: Amit Kapila <akapila@postgresql.org>
15041565
2021-12-08 [1a2aaeb0d] Fix changing the ownership of ALL TABLES IN SCHEMA publi
1566+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
1567+
2022-09-22 [f256236fb] Remove ALL keyword from TABLES IN SCHEMA for publication
15051568
-->
15061569

15071570
<listitem>
@@ -1513,7 +1576,7 @@ Author: Amit Kapila <akapila@postgresql.org>
15131576
<para>
15141577
For example, this syntax is now supported: <link
15151578
linkend="sql-createpublication"><command>CREATE PUBLICATION pub1
1516-
FOR ALL TABLES IN SCHEMA s1,s2;</command></link> <command>ALTER
1579+
FOR TABLES IN SCHEMA s1,s2;</command></link> <command>ALTER
15171580
PUBLICATION</command> supports a similar syntax. Tables added
15181581
later to the listed schemas will also be replicated.
15191582
</para>
@@ -1864,6 +1927,29 @@ Author: Michael Paquier <michael@paquier.xyz>
18641927
</para>
18651928
</listitem>
18661929

1930+
<!--
1931+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1932+
2022-07-22 [c2fa113dd] Close old gap in dependency checks for functions returni
1933+
-->
1934+
1935+
<listitem>
1936+
<para>
1937+
Track dependencies on individual columns in the results of
1938+
functions returning composite types (Tom Lane)
1939+
</para>
1940+
1941+
<para>
1942+
Previously, if a view or rule contained a reference to a specific
1943+
column within the result of a composite-returning function, that
1944+
was not noted as a dependency; the view or rule was only considered
1945+
to depend on the composite type as a whole. This meant that
1946+
dropping the individual column would be allowed, causing problems
1947+
in later use of the view or rule. The column-level dependency is
1948+
now also noted, so that dropping such a column will be rejected
1949+
unless the view is changed or dropped.
1950+
</para>
1951+
</listitem>
1952+
18671953
</itemizedlist>
18681954

18691955
</sect3>
@@ -1903,6 +1989,18 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
19031989
</para>
19041990
</listitem>
19051991

1992+
<!--
1993+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1994+
2022-08-02 [c034b629c] Change type "char"'s I/O format for non-ASCII characters
1995+
-->
1996+
1997+
<listitem>
1998+
<para>
1999+
Change the I/O format of type <type>"char"</type> for non-ASCII
2000+
characters (Tom Lane)
2001+
</para>
2002+
</listitem>
2003+
19062004
<!--
19072005
Author: Peter Eisentraut <peter@eisentraut.org>
19082006
2022-04-07 [344d62fb9] Unlogged sequences
@@ -2341,6 +2439,28 @@ Author: Peter Eisentraut <peter@eisentraut.org>
23412439
</para>
23422440
</listitem>
23432441

2442+
<!--
2443+
Author: Michael Paquier <michael@paquier.xyz>
2444+
2022-06-15 [a3ff08e0b] Tweak behavior of psql - -single-transaction depending
2445+
-->
2446+
2447+
<listitem>
2448+
<para>
2449+
After an error is detected
2450+
in <option>--single-transaction</option> mode, change the
2451+
final <command>COMMIT</command> command
2452+
to <command>ROLLBACK</command> only
2453+
if <varname>ON_ERROR_STOP</varname> is set (Michael Paquier)
2454+
</para>
2455+
2456+
<para>
2457+
Previously, detection of an error in a <option>-c</option> command
2458+
or <option>-f</option> script file would lead to
2459+
issuing <command>ROLLBACK</command> at the end, regardless of the
2460+
value of <varname>ON_ERROR_STOP</varname>.
2461+
</para>
2462+
</listitem>
2463+
23442464
<!--
23452465
Author: Michael Paquier <michael@paquier.xyz>
23462466
2021-08-10 [e2ce88b58] Add tab completion for DECLARE .. ASENSITIVE in psql
@@ -2714,17 +2834,20 @@ Author: Michael Paquier <michael@paquier.xyz>
27142834
2022-02-06 [38bfae365] pg_upgrade: Move all the files generated internally to a
27152835
Author: Michael Paquier <michael@paquier.xyz>
27162836
2022-02-15 [a00849630] Fix thinko with subdirectories generated by pg_upgrade f
2837+
Author: Michael Paquier <michael@paquier.xyz>
2838+
2022-09-13 [f5047c129] Move any remaining files generated by pg_upgrade into an
27172839
-->
27182840

27192841
<listitem>
27202842
<para>
2721-
Store <application>pg_upgrade</application>
2722-
temporary files in a new cluster subdirectory called
2843+
Store <application>pg_upgrade</application>'s log and
2844+
temporary files in a subdirectory of the new cluster called
27232845
<filename>pg_upgrade_output.d</filename> (Justin Pryzby)
27242846
</para>
27252847

27262848
<para>
2727-
Previously temporary files were stored in the current directory.
2849+
Previously such files were left in the current directory,
2850+
requiring manual cleanup.
27282851
</para>
27292852
</listitem>
27302853

@@ -2733,6 +2856,8 @@ Author: Robert Haas <rhaas@postgresql.org>
27332856
2022-01-17 [9a974cbcb] pg_upgrade: Preserve relfilenodes and tablespace OIDs.
27342857
Author: Robert Haas <rhaas@postgresql.org>
27352858
2022-01-24 [aa0105141] pg_upgrade: Preserve database OIDs.
2859+
Author: Robert Haas <rhaas@postgresql.org>
2860+
2022-07-28 [4ab5dae94] Use TRUNCATE to preserve relfilenode for pg_largeobject
27362861
-->
27372862

27382863
<listitem>
@@ -3068,14 +3193,14 @@ Author: Peter Eisentraut <peter@eisentraut.org>
30683193
</listitem>
30693194

30703195
<!--
3071-
Author: Andres Freund <andres@anarazel.de>
3072-
2022-02-16 [19252e8ec] plpython: Reject Python 2 during build configuration.
3196+
Author: Tom Lane <tgl@sss.pgh.pa.us>
3197+
2022-07-23 [3b474a2e6] Increase minimum supported GNU make version to 3.81.
30733198
-->
30743199

30753200
<listitem>
30763201
<para>
3077-
Disallow building with <application>Python 2</application>
3078-
(Andres Freund)
3202+
Require GNU <application>make</application> version 3.81 or later
3203+
to build <productname>PostgreSQL</productname> (Tom Lane)
30793204
</para>
30803205
</listitem>
30813206

@@ -3086,11 +3211,23 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
30863211

30873212
<listitem>
30883213
<para>
3089-
Adjust configure to require <application>Perl</application>
3214+
Require <application>Perl</application>
30903215
version 5.8.3 or later (Dagfinn Ilmari Mannsåker)
30913216
</para>
30923217
</listitem>
30933218

3219+
<!--
3220+
Author: Andres Freund <andres@anarazel.de>
3221+
2022-02-16 [19252e8ec] plpython: Reject Python 2 during build configuration.
3222+
-->
3223+
3224+
<listitem>
3225+
<para>
3226+
Require <application>Python</application>
3227+
version 3.2 or later (Andres Freund)
3228+
</para>
3229+
</listitem>
3230+
30943231
</itemizedlist>
30953232

30963233
</sect3>

0 commit comments

Comments
 (0)