<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.596 2009/03/2602:48:53 momjian Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.597 2009/03/2603:46:14 tgl Exp $ -->

<!--

Typical markup:

<note>

<title>Release date</title>

<simpara>2009-XX-XX, ITEMS CURRENT AS OF 2009-03-16</simpara>

<simpara>2009-XX-XX, ITEMS CURRENT AS OF 2009-03-16</simpara>

</note>

<sect2>

<listitem>

<para>

Disable appending of the epoch date/time when '%' escapes are missing in

log_filename (Robert Haas)

Disable appending of the epoch date/time whenno'%' escapes are

present inlog_filename (Robert Haas)

</para>

<para>

This change was made because some users wanted aconsistent log

filename.

This change was made because some users wanted aconstant log filename,

for use with an external log rotation tool.

</para>

</listitem>

<listitem>

<para>

Throw an errorof an escape character is the last character in a LIKE

pattern (nothing to escape) (Tom)

Throw an errorif an escape character is the last character in a LIKE

pattern (it hasnothing to escape) (Tom)

</para>

</listitem>

<listitem>

<para>

Remove ~=~ and ~<>~ operators used for LIKE index comparisons (Tom) bjm:

Remove ~=~ and ~&lt;&gt;~ operators used for LIKE index comparisons

</para>

<para>

<listitem>

<para>

Add postgresql.conf setting cursor_tuple_fraction to control the

Add postgresql.conf setting cursor_tuple_fraction to control the

fraction of a cursor's rows expected to be requested by the user (Robert

Hell)

</para>

<listitem>

<para>

OFFSET num {ROW|ROWS} FETCH {FIRST|NEXT} [num] {ROW|ROWS} ONLY.

OFFSET num {ROW|ROWS} FETCH {FIRST|NEXT} [num] {ROW|ROWS} ONLY.

</para>

</listitem>

<listitem>

<para>

New syntax supported (these formerly required "ALTER TABLE")

New syntax supported (these formerly required "ALTER TABLE")

</para>

</listitem>

</listitem>

<listitem>

<para>

ALTER VIEW ALTER COLUMN SET/DROP DEFAULT

ALTER VIEW ALTER COLUMN SET/DROP DEFAULT

</para>

</listitem>

<listitem>

<para>

ALTER VIEW OWNER TO

ALTER VIEW OWNER TO

</para>

</listitem>

<listitem>

<para>

ALTER VIEW SET SCHEMA

ALTER VIEW SET SCHEMA

</para>

</listitem>

</itemizedlist>

<para>

Previously EXPLAIN VERBOSE output an internal representation of the

</para>

</listitem>

<listitem>

<para>

Have EXPLAIN honor debug_print_plan (Tom) bjm: verify behavior, this

replaces EXPLAIN VERBOSE?

Have EXPLAIN honor debug_print_plan (Tom)

</para>

</listitem>

<listitem>

<para>

Dramatically improve the speed of building and accessing hash indexes

(Tom Raney, Shreya Bhargava, Kenneth Marshall, Tom)

(Tom Raney, Shreya Bhargava, Kenneth Marshall)

</para>

<para>

This allows hash indexes to beoften faster than btree indexes.

This allows hash indexes to besometimes faster than btree indexes.

However, hash indexes are still not crash-safe.

</para>

</listitem>

<itemizedlist>

<listitem>

<para>

Support DETAIL and HINT fields

Support DETAIL and HINT fields

</para>

</listitem>

<listitem>

<para>

Support SQLSTATE error codes

Support SQLSTATE error codes

</para>

</listitem>

<listitem>

<para>

Support an exception name parameter

Support an exception name parameter

</para>

</listitem>

<listitem>

<para>

Allow RAISE without parameters in an exception

block to rethrow the current error

Allow RAISE without parameters in an exception

block to rethrow the current error

</para>

</listitem>

</itemizedlist>