<note>

<title>Release Date</title>

<simpara>2012-??-??</simpara>

<simpara>CURRENT AS OF 2012-08-21</simpara>

<simpara>2012-09-10</simpara>

</note>

<sect2>

<listitem>

<para>

Allow <application>pg_basebackup</> to make base backups from

standby servers

Allow <link

linkend="app-pgbasebackup"><application>pg_basebackup</></link>

to make base backups from standby servers

</para>

</listitem>

<listitem>

<para>

No longer forcibly lowercase procedural language names (Robert Haas)

No longer forcibly lowercase procedural language names in <link

linkend="SQL-CREATEFUNCTION"><command>CREATE FUNCTION</></link>

(Robert Haas)

</para>

<para>

<listitem>

<para>

Reduce overhead of creating virtual transactionid locks (Robert

Reduce overhead of creating virtual transactionID locks (Robert

Haas)

</para>

</listitem>

</para>

<para>

This allows Windows sessions to use more open file descriptors.

This allows Windows sessions to use more open file descriptors than

before.

</para>

</listitem>

</para>

<para>

This is onlyenabled when <link

Thischeckis onlyperformed when <link

linkend="guc-constraint-exclusion"><varname>constraint_exclusion</></link>

is <literal>on</literal>.

</para>

<para>

This change improves selectivity estimation for the array

<literal>&lt;@</literal>, <literal>&amp;&amp;</literal>, and

<literal>@&gt;</literal>(containment and overlaps) array operators.

<literal>@&gt;</literal>operators (arraycontainment and overlaps).

</para>

</listitem>

Change <quote>unexpected EOF</> messages to <literal>DEBUG1</> level,

except when there is an open transaction (Magnus Hagander)

</para>

<para>

This change reduces log chatter caused by applications that close

database connections ungracefully.

</para>

</listitem>

</itemizedlist>

Silently ignore nonexistent schemas specified in <link

linkend="guc-search-path"><varname>search_path</></link> (Tom Lane)

</para>

<para>

This makes it more convenient to use generic path settings, which

might include some schemas that don't exist in all databases.

</para>

</listitem>

<listitem>

<para>

The system now remembers whether a <command>SET</command> was

performed by a superuser.

performed by a superuser, so that proper privilege checking can be

done when the extension is loaded.

</para>

</listitem>

<listitem>

<para>

Allow streaming of WAL files while <link linkend="app-pgbasebackup"><application>pg_basebackup</></link>

is performing a backup (Magnus Hagander)

Allow <link

linkend="app-pgbasebackup"><application>pg_basebackup</></link>

to make base backups from standby servers (Jun Ishizuka, Fujii Masao)

</para>

<para>

Thisallows passing of WAL files to the standby before they are

discarded onthe primary.

Thisfeature lets the work of making new base backups be off-loaded

fromthe primary server.

</para>

</listitem>

<listitem>

<para>

Allow <application>pg_basebackup</> to make base backups from

standby servers (Jun Ishizuka, Fujii Masao)

Allow streaming of WAL files while <application>pg_basebackup</>

is performing a backup (Magnus Hagander)

</para>

<para>

This allows passing of WAL files to the standby before they are

discarded on the primary.

</para>

</listitem>

<listitem>

<para>

Cancel queries if clients get disconnected (Florian Pflug)

Cancel the running query if the client gets disconnected

(Florian Pflug)

</para>

<para>

If the backend detects loss of client connection during a query, it

will now cancel the query rather than attempting to finish it.

</para>

</listitem>

<listitem>

<para>

Warn about casts toand from domain types (Robert Haas)

Warn aboutcreatingcasts toor from domain types (Robert Haas)

</para>

<para>

<listitem>

<para>

Improve prettyprinting of view definitions (Andrew Dunstan)

Improve pretty-printing of view definitions (Andrew Dunstan)

</para>

</listitem>

<para>

Reduce need to rebuild tables and indexes for certain <link

linkend="SQL-ALTERTABLE"><command>ALTER TABLE</command></link>

operations (Noah Misch)

... <literal>ALTER COLUMN TYPE</>operations (Noah Misch)

</para>

<para>

Increasing the length limit for a <type>varchar</> or <type>varbit</>

column, or removingit altogether, no longer requires a table

column, or removingthe limit altogether, no longer requires a table

rewrite. Similarly, increasing the allowable precision of a

<type>numeric</> column, or changing a column from constrained

<type>numeric</> to unconstrained <type>numeric</>, no longer

<listitem>

<para>

Add <literal>IF EXISTS</>clause to some <command>ALTER</command>

Add <literal>IF EXISTS</>options to some <command>ALTER</command>

commands (Pavel Stehule)

</para>

<listitem>

<para>

Allowvacuumto more easily skip pages that cannot be locked

(Simon Riggs, Robert Haas)

Allow<link linkend="SQL-VACUUM"><command>VACUUM</></link>to more

easily skip pages that cannot be locked(Simon Riggs, Robert Haas)

</para>

<para>

This change should greatly reduce the incidence ofvacuum getting

<quote>stuck</>.

This change should greatly reduce the incidence of<command>VACUUM</>

getting<quote>stuck</> waiting for other sessions.

</para>

</listitem>

</para>

<para>

Previously only superuserscould use these functions.

Previously only superuserswere allowed to use these functions.

</para>

</listitem>

<listitem>

<para>

Allow inclusion of a script filerelative to the directory of the

file from which it was invoked (Gurjeet Singh)

Allow inclusion of a script filethat is named relative to the

directory of thefile from which it was invoked (Gurjeet Singh)

</para>

<para>

</para>

<para>

Specifically,<envar>PSQL_HISTORY</envar> and

<envar>PSQLRC</envar>determine these file names if set.

<envar>PSQL_HISTORY</envar> and <envar>PSQLRC</envar> now

determine these file names if set.

</para>

</listitem>

<listitem>

<para>

Make <application>psql</>'s temporary editor filesuse a

Name <application>psql</>'s temporary editor fileswith a

<filename>.sql</> extension (Peter Eisentraut)

</para>

</para>

<para>

Various shell tools use zero-byte (NUL) separators, e.g. find.

Various shell tools use zero-byte (NUL) separators,

e.g. <application>find</>.

</para>

</listitem>