</para>

<para>

This was already disabled by default in previous Postgres releases,

longer support it.

This was already disabled by default in previous

OpenSSL and <acronym>TLS</acronym> versions nolonger support it.

</para>

</listitem>

</para>

<para>

This was last used as the default in Postgres 7.3 (year 2002).

This was last used as the default in

<productname>PostgreSQL</productname> 7.3 (year 2002).

</para>

</listitem>

<para>

<function>EXTRACT(date)</function> now throws an error for units

that are not part of the date data type.

that are not part of the<type>date</type> data type.

</para>

</listitem>

-->

<para>

Improve handling of regular expression back-references (Tom Lane)

Improve handling of regular expression <link

linkend="posix-escape-sequences">back-references</link> (Tom Lane)

</para>

<para>

<para>

Require <link linkend="runtime-config-custom">custom server

variable</link> names to use onlycharacter which are valid for

variable</link> names to use onlycharacters which are valid for

unquoted <acronym>SQL</acronym> identifiers (Tom Lane)

</para>

</listitem>

-->

<para>

Pass doubled quote marks in <xref linkend="ecpg"/>

Pass doubled quote marks in <link linkend="ecpg">ecpg</link>

<acronym>SQL</acronym> command strings literally (Tom Lane)

</para>

<para>

This is useful if only a small percentage of rows is checked on

the inner side.

the inner side and is controlled by <xref

linkend="guc-enable-resultcache"/>.

</para>

</listitem>

</para>

<para>

The<link

<link

linkend="postgres-fdw"><application>postgres_fdw</application></link>

supports these type of scans if <literal>async_capable</literal>

is set.

<para>

This is controlled by server variable <xref

linkend="guc-ssl-crl-dir"/> and libpq connection option sslcrldir.

Previously only <acronym>CRL</acronym> files could be specified.

linkend="guc-ssl-crl-dir"/> and libpq connection option

<xref linkend='libpq-connect-sslcrldir'/>. Previously only

<acronym>CRL</acronym> files could be specified.

</para>

</listitem>

</para>

<para>

By default, Postgres opens and fsyncs every data file

at the start of crash recovery. This new setting, <xref

By default, <productname>PostgreSQL</productname>

opens and fsyncs every data file at the

start of crash recovery. This new setting, <xref

linkend="guc-recovery-init-sync-method"/><literal>=syncfs</literal>,

instead syncs each filesystem used by the database cluster.

This allows for faster recovery on systems with many database files.

</para>

<para>

This is similar to how Unicode can be specified in literalstring.

This is similar to how Unicode can be specified in literalstrings.

</para>

</listitem>

The new syntax is <literal>SUBSTRING(text SIMILAR pattern ESCAPE

escapechar)</literal>. The previous standard syntax was

<literal>SUBSTRING(text FROM pattern FOR escapechar)</literal>,

and is still supported byPostgres.

and is still supported by<productname>PostgreSQL</productname>.

</para>

</listitem>

<para>

Add <link

linkend="posix-escape-sequences"><literal>[[:word:]]</literal></link>

as a character class to match\w (Tom Lane)

as a character class to match<literal>\w</literal> (Tom Lane)

</para>

</listitem>

-->

<para>

Allow <application>psql</application>'s \df and \do commands to

specify functionandoperator argument types (Greg Sabino Mullane,

Tom Lane)

Allow <application>psql</application>'s<literal>\df</literal>

and<literal>\do</literal> commands to specify function and

operator argument types (Greg Sabino Mullane,Tom Lane)

</para>

<para>

-->

<para>

Allow <application>psql</application>'s \dt and \di to show

<acronym>TOAST</acronym> tables and their indexes (Justin Pryzby)

Allow <application>psql</application>'s <literal>\dt</literal>

and <literal>\di</literal> to show <acronym>TOAST</acronym>

tables and their indexes (Justin Pryzby)

</para>

</listitem>

-->

<para>

Add <application>psql</application> command \dX to list extended

statistics objects (Tatsuro Yamada)

Add <application>psql</application> command<literal>\dX</literal>

to list extendedstatistics objects (Tatsuro Yamada)

</para>

</listitem>

-->

<para>

Fix <application>psql</application>'s \dT to understand array

syntax and backend grammar aliases, like "int" for "integer"

(Greg Sabino Mullane, Tom Lane)

Fix <application>psql</application>'s<literal>\dT</literal> to

understand arraysyntax and backend grammar aliases, like "int"

for "integer"(Greg Sabino Mullane, Tom Lane)

</para>

</listitem>

<para>

When editing the previous query or a file with

<application>psql</application>'s \e, or using \ef and \ev, ignore

the contents if the editor exits without saving (Laurenz Albe)

<application>psql</application>'s <literal>\e</literal>, or using

<literal>\ef</literal> and <literal>\ev</literal>, ignore the

contents if the editor exits without saving (Laurenz Albe)

</para>

<para>

-->

<para>

Improve <application>psql</application>'s handling of \connect

with <option>-reuse-previous</option> (Tom Lane)

Improve <application>psql</application>'s handling of

<literal>\connect</literal> with <option>-reuse-previous</option>

(Tom Lane)

</para>

<para>

Stop <link

linkend="pgupgrade"><application>pg_upgrade</application></link>

from creating <filename>analyze_new_cluster</filename> script

(Michael Paquier)

(Magnus Hagander)

</para>

<para>

-->

<para>

Allow <function>pgstattuple_approx()</function> to report on

<acronym>TOAST</acronym> tables (Peter Eisentraut)

Allow <link

linkend="pgstattuple"><function>pgstattuple_approx()</function></link>

to report on <acronym>TOAST</acronym> tables (Peter Eisentraut)

</para>

</listitem>