<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.465 2006/10/0720:59:03 petere Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.466 2006/10/0722:06:25 momjian Exp $ -->

<!--

Typical markup:

<listitem>

<para>

Add <literal>FILLFACTOR</> to <link

linkend="SQL-CREATETABLE">table</> and <link

linkend="SQL-CREATEINDEX">index</> creation (ITAGAKI

linkend="SQL-CREATETABLE">table</link> and <link

linkend="SQL-CREATEINDEX">index</link> creation (ITAGAKI

Takahiro)

</para>

<listitem>

<para>

Allow the planner to reorder <link linkend="queries-join">outer

joins</> in some circumstances (Tom)

joins</link> in some circumstances (Tom)

</para>

<para>

<listitem>

<para>

Improve planning of joins to <link linkend="ddl-inherit">inherited

tables</> and <link linkend="queries-union"><literal>UNION

tables</link> and <link linkend="queries-union"><literal>UNION

ALL</></link> views (Tom)

</para>

</listitem>

<listitem>

<para>

Allow <link linkend="guc-constraint-exclusion">constraint

exclusion</> to be applied to <link

linkend="ddl-inherit">inherited</> <command>UPDATE</> and

exclusion</link> to be applied to <link

linkend="ddl-inherit">inherited</link> <command>UPDATE</> and

<command>DELETE</> queries (Tom)

</para>

<listitem>

<para>

Add support for <link linkend="config-setting">include

directives</> in <filename>postgresql.conf</> (Joachim

directives</link> in <filename>postgresql.conf</> (Joachim

Wieland)

</para>

</listitem>

<listitem>

<para>

Add new aggregate creation <link

linkend="SQL-CREATEAGGREGATE">syntax</> (Tom)

linkend="SQL-CREATEAGGREGATE">syntax</link> (Tom)

</para>

<para>

<listitem>

<para>

<link linkend="SQL-CREATEAGGREGATE">Aggregate functions</>

<link linkend="SQL-CREATEAGGREGATE">Aggregate functions</link>

now support multiple input parameters (Sergey Koposov, Tom)

</para>

</listitem>

<listitem>

<para>

Allow <link linkend="SQL-COMMENT">comments</> on global

Allow <link linkend="SQL-COMMENT">comments</link> on global

objects to be stored globally (Kris Jurka)

</para>

<listitem>

<para>

Provide <link linkend="functions-advisory-locks">advisory

locking</> functionality (Abhijit Menon-Sen, Tom)

locking</link> functionality (Abhijit Menon-Sen, Tom)

</para>

<para>

<listitem>

<para>

New <link linkend="functions-geometry-op-table">operators</>

New <link linkend="functions-geometry-op-table">operators</link>

for array-subset comparisons (<literal>@&gt;</>,

<literal>&lt;@</>, <literal>&amp;&amp;</>) (Teodor, Tom)

</para>

<listitem>

<para>

Add convenient arithmetic <link

linkend="cidr-inet-operators-table">operations</> on

linkend="cidr-inet-operators-table">operations</link> on

<type>INET</>/<type>CIDR</> values (Stephen R. van den

Berg)

</para>

<listitem>

<para>

Add new aggregate <link

linkend="functions-aggregate-statistics-table">functions</>

linkend="functions-aggregate-statistics-table">functions</link>

from SQL2003 (Neil)

</para>

<listitem>

<para>

Allow <link linkend="SQL-CREATEDOMAIN">domains</> to be

Allow <link linkend="SQL-CREATEDOMAIN">domains</link> to be

created using other domains (Tom)

</para>

</listitem>

<listitem>

<para>

Allow <acronym>LDAP</> <link linkend="libpq-ldap">lookups</>

Allow <acronym>LDAP</> <link linkend="libpq-ldap">lookups</link>

from <link

linkend="libpq-pgservice"><filename>pg_service.conf</></link>

(Laurenz Albe)

<listitem>

<para>

Re-implement the <link linkend="regress">regression test</> script as a C program

Re-implement the <link linkend="regress">regression test</link> script as a C program

(Magnus, Tom)

</para>

</listitem>

</para>

<para>

New <link linkend="xfunc-c-dynload">functions</> <function>_PG_init()</> and <function>_PG_fini()</>

are called if the library defines such symbols. Hence we

no longer need to specify an initialization function in

<varname>shared_preload_libraries</>; we can assume that the

library used the <function>_PG_init()</> convention instead.

New <link linkend="xfunc-c-dynload">functions</link>

<function>_PG_init()</> and <function>_PG_fini()</> are

called if the library defines such symbols. Hence we no

longer need to specify an initialization function in

<varname>shared_preload_libraries</>; we can assume that

the library used the <function>_PG_init()</> convention

instead.

</para>

</listitem>