Cause large object permission checks

to happen on large object open, <link

linkend="lo-open"><function>lo_open()</function></link>, not

read/write (Tom Lane)

read/write (Tom Lane, Michael Paquier)

</para>

</listitem>

<productname>PostgreSQL</productname> has long supported a more

standard-compliant syntax for this capability.

</para>

</listitem>

<listitem>

<!--

Branch: master [6bdf1303b] Avoid wrong results for power() with NaN

-->

<para>

Consistently return <literal>NaN</literal> for

<literal>NaN</literal> inputs to <function>power()</function>

on older platforms (Dang Minh Huong)

</para>

</listitem>

</para>

<para>

Previously each hash index entry hastobe locked and scanned

separately.

Previouslyforeach hash index entry, we needtorefind the scan

position within the page. This cuts down on lock/unlock traffic.

</para>

</listitem>

<para>

Add information_schema columns related to table constraints and

triggers (Michael Paquier)

triggers (Peter Eisentraut)

</para>

<para>

<para>

Add libpq option to support channel binding when using <link

linkend="auth-password"><acronym>SCRAM</acronym></link>

authentication (Michael Paquier)

authentication (Peter Eisentraut)

</para>

<para>

Channel binding requires the server end

of the <acronym>TLS</acronym> connection to

prove that it knows the password. The options are <link

While <acronym>SCRAM</acronym> always prevents the

replay of transmitted hashed passwords in a later

session, <acronym>SCRAM</acronym> with channel binding

also prevents man-in-the-middle attacks. The options are <link

linkend="libpq-scram-channel-binding"><option>scram_channel_binding=tls-unique</option></link>

and <option>scram_channel_binding=tls-server-end-point</option>.

</para>

<para>

WHAT DOES THIS DOC TEXT MEAN? "An empty value specifies that

the client will not use channel binding. The default value

is tls-unique."

</para>

</listitem>

<listitem>

<para>

Allow access to file system functions to be controlled by

<command>GRANT</command>/<command>REVOKE</command> permissions,

rather than super-user checks (Michael Paquier)

rather than super-user checks (Stephen Frost)

</para>

<para>

Use <command>GRANT</command>/<command>REVOKE</command>

to control access to <link

linkend="lo-import"><function>lo_import()</function></link>

and <function>lo_export()</function> (Michael Paquier)

and <function>lo_export()</function> (Michael Paquier, Tom Lane)

</para>

<para>

<!--

2018-03-23 [8694cc96b] Exclude unlogged tables from base backups

2018-03-27 [920a5e500] Skip temp tables from basebackup.

2017-11-07 [98267ee83] Exclude pg_internal.init from BASE_BACKUP

-->

<para>

Exclude unlogged and temporary tables from streaming base backups

(David Steele)

Exclude unlogged, temporary tables, and

<filename>pg_internal.init</filename> files from streaming base

backups (David Steele)

</para>

<para>

<para>

Add timeline information to the <link

linkend="backup-lowlevel-base-backup"><filename>backup_label</filename></link>

file (Simon Riggs)

file (Michael Paquier)

</para>

<para>

</para>

</listitem>

<listitem>

<!--

2017-11-07 [98267ee83] Exclude pg_internal.init from BASE_BACKUP

-->

<para>

Document that <filename>pg_internal.init</filename> files do not

need to be included in the base backup (David Steele)

</para>

</listitem>

</itemizedlist>

</sect3>

-->

<para>

Allow <command>ALTER TABLE</command> to add a non-null default

column without a table rewrite (Andrew Dunstan, Serge Rielau)

Allow <command>ALTER TABLE</command> to add a column with

a non-null default without a table rewrite (Andrew Dunstan,

Serge Rielau)

</para>

</listitem>

<listitem>

<!--

2018-03-06 [0c2c81b40] doc: Add replication parameter to libpq documentation

-->

<para>

Add libpq parameter to allow physical and logical replication

connections (Michael Paquier)

</para>

<para>

The libpq connection parameter is called <link

linkend="libpq-connect-replication"><option>replication</option></link>.

</para>

</listitem>

<listitem>

<!--

2018-03-17 [e3bdb2d92] Set libpq sslcompression to off by default

-->

-->

<para>

Have<application>psql</application> \d+ showa partitioncount

of zero (Amit Langote)

Have psql \d+alwaysshowthe partitioninformation (Amit Langote,

Ashutosh Bapat)

</para>

<para>

Previouslynopartition information would be displayed forsuch

tables. Also indicate whichpartitions are themselves partitioned.

Previously partition information wouldnotbe displayed fora

partitioned table if it had nopartitions. Also indicate which

</para>

</listitem>

Add <link

linkend="app-pgreceivewal"><application>pg_receivewal</application></link>

option <option>--no-sync</option> to prevent synchronous

<acronym>WAL</acronym> writes (Michael Paquier)

<acronym>WAL</acronym> writes, for testing (Michael Paquier)

</para>

</listitem>

<para>

Prevent <application>pg_rewind</application> from running as

<literal>root</literal> (Magnus Hagander)

<literal>root</literal> (Michael Paquier)

</para>

</listitem>