<para>

Previously, the string value of such variables was set to match the variable name during cursor assignment; now it will be assigned during OPEN, and will not match the variable name.

To restore the previous behavior, assign the desired portal name to the cursor variable before OPEN.

</para>

</listitem>

<listitem>

<para>

Allow memoize atopof UNION ALL and partitions (Richard Guo)

Allow memoize atopa UNION ALL (Richard Guo)

</para>

</listitem>

<listitem>

<para>

Allow anti-joins to beconstructed on theright/outer side (Richard Guo)

Allow anti-joins to beperformed with thenon-nullable input as the inner relation (Richard Guo)

</para>

</listitem>

</para>

<para>

Previously only a single privilegenames, like SELECT,were supported.

Previously only a single privilegename, like SELECT,was accepted.

</para>

</listitem>

<listitem>

<para>

Store server variables in a hash table (Tom Lane)

</para>

<para>

This allows the faster addition of server variables.

Improve performance of server variable management (Tom Lane)

</para>

</listitem>

</para>

<para>

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_crash.

</para>

</listitem>

<listitem>

<para>

Remove theunnecessary postmaster -n option (Tom Lane)

Remove thenon-functional postmaster -n option (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Add EXPLAIN option GENERIC_PLAN to display thequery'sgeneric plan (Laurenz Albe)

Add EXPLAIN option GENERIC_PLAN to display the generic plan for a parameterized query (Laurenz Albe)

</para>

</listitem>

<listitem>

<para>

Add VACUUMoption to skip or update all frozen statistics (Tom Lane, Nathan Bossart)

Add VACUUMoptions to skip or update all frozen statistics (Tom Lane, Nathan Bossart)

</para>

<para>

<!--

Author: Tom Lane <tgl@sss.pgh.pa.us>

2023-01-01 [2ceea5adb] Accept "+infinity" in date and timestamp[tz] input.

-->

<listitem>

<para>

Accept the spelling "+infinity" in datetime input (Vik Fearing)

</para>

</listitem>

<!--

Author: Tom Lane <tgl@sss.pgh.pa.us>

2023-03-09 [bcc704b52] Reject combining "epoch" and "infinity" with other datet

-->

<listitem>

<para>

Prevent the specification of "epoch" and "infinity" with otherunits in datetime strings (Joseph Koshakow)

Prevent the specification of "epoch" and "infinity"togetherwith otherfields in datetime strings (Joseph Koshakow)

</para>

</listitem>

<listitem>

<para>

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

"<literal>Y<replaceable>year</replaceable>M<replaceable>month</replaceable>D<replaceable>day</replaceable></literal>"

(Joseph Koshakow)

</para>

</listitem>

<listitem>

<para>

Allow to_reg* functions to accept OIDsparameters (Tom Lane)

Allow to_reg* functions to acceptnumericOIDsas input (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Allow ECPG variable declarations to usetype nameswhich match SQL keywords (Tom Lane)

Allow ECPG variable declarations to usetypedef namesthat match unreserved SQL keywords (Tom Lane)

</para>

<para>

<listitem>

<para>

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 queries

(Corey Huinker, Tom Lane)

</para>

<para>

<listitem>

<para>

Prevent extension libraries from export their symbols by default (Andres Freund, Tom Lane)

Prevent extension libraries from exporting their symbols by default (Andres Freund, Tom Lane)

</para>

<para>

Functions that need to be called from the core backend or other extensions must now be explicitly marked PGDLLEXPORT.

</para>

</listitem>

<listitem>

<para>

Allow the schemas ofdependent extensions to be referenced using the new syntax @extschema:dependent_extension_name@ (Regina Obe)

Allow the schemas ofrequired extensions to be referencedin extension scriptsusing the new syntax @extschema:referenced_extension_name@ (Regina Obe)

</para>

</listitem>

<listitem>

<para>

Allowdependent extensions to marked as non-relocatable using "no_relocate" (Regina Obe)

Allowrequired extensions to marked as non-relocatable using "no_relocate" (Regina Obe)

</para>

<para>

This allows @extschema:dependent_extension_name@ to be treated as a constant for the lifetime of the extension.

This allows @extschema:referenced_extension_name@ to be treated as a constant for the lifetime of the extension.

</para>

</listitem>