<   reindex rather than update the index.
>   reindex rather than update the index.  Also, index updates can
>   bloat the index.

> 	o ARRAY[[1,2],[3,4]])[1] should return the same values as
> 	  ARRAY[[1,2],[3,4]])[1:1];
>

< * Add Globally/Universally Unique Identifier (GUID/UUID)
> * -Add Globally/Universally Unique Identifier (GUID/UUID)

> * Enforce typmod for function inputs, function results and parameters for
>   spi_prepare'd statements called from PLs
>
>   http://archives.postgresql.org/pgsql-hackers/2007-01/msg01403.php

> * Consider having the background writer update the transaction status
>   hint bits before writing out the page

>
> * Consider increasing NUM_CLOG_BUFFERS

>   http://archives.postgresql.org/pgsql-hackers/2007-01/msg01025.php

> 	o -Add a GUC variable to control the tablespace for temporary objects

discussions.

<
<
< ---------------------------------------------------------------------------
<
<
< Developers who have claimed items are:
< --------------------------------------
< * Alvaro is Alvaro Herrera <alvherre@dcc.uchile.cl>
< * Andrew is Andrew Dunstan <andrew@dunslane.net>
< * Bruce is Bruce Momjian <bruce@momjian.us> of EnterpriseDB
< * Christopher is Christopher Kings-Lynne <chriskl@familyhealth.com.au> of
<     Family Health Network
< * D'Arcy is D'Arcy J.M. Cain <darcy@druid.net> of The Cain Gang Ltd.
< * David is David Fetter <david@fetter.org>
< * Fabien is Fabien Coelho <coelho@cri.ensmp.fr>
< * Gavin is Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering
< * Greg is Greg Sabino Mullane <greg@turnstep.com>
< * Jan is Jan Wieck <JanWieck@Yahoo.com> of Afilias, Inc.
< * Joe is Joe Conway <mail@joeconway.com>
< * Karel is Karel Zak <zakkr@zf.jcu.cz>
< * Magnus is Magnus Hagander <mha@sollentuna.net>
< * Marc is Marc Fournier <scrappy@hub.org> of PostgreSQL, Inc.
< * Matthew T. O'Connor <matthew@zeut.net>
< * Michael is Michael Meskes <meskes@postgresql.org> of Credativ
< * Neil is Neil Conway <neilc@samurai.com>
< * Oleg is Oleg Bartunov <oleg@sai.msu.su>
< * Pavel is Pavel Stehule <pavel.stehule@hotmail.com>
< * Peter is Peter Eisentraut <peter_e@gmx.net>
< * Philip is Philip Warner <pjw@rhyme.com.au> of Albatross Consulting Pty. Ltd.
< * Rod is Rod Taylor <pg@rbt.ca>
< * Simon is Simon Riggs <simon@2ndquadrant.com>
< * Stephan is Stephan Szabo <sszabo@megazone23.bigpanda.com>
< * Tatsuo is Tatsuo Ishii <ishii@sraoss.co.jp> of SRA OSS, Inc. Japan
< * Teodor is Teodor Sigaev <teodor@sigaev.ru>
< * Tom is Tom Lane <tgl@sss.pgh.pa.us> of Red Hat

< 	o Add -f to pg_dumpall
> 	o -Add -f to pg_dumpall

>
>   http://archives.postgresql.org/pgsql-hackers/2006-12/msg01107.php

>
>   http://archives.postgresql.org/pgsql-hackers/2006-12/msg01188.php
>   http://archives.postgresql.org/pgsql-hackers/2007-01/msg00121.php

< first.
> first.  There is also a developer's wiki at
> http://developer.postgresql.org.

> 	o Allow multiple vacuums so large tables do not starve small
> 	  tables
>
> 	  http://archives.postgresql.org/pgsql-general/2007-01/msg00031.php
>
> 	o Improve control of auto-vacuum
>
> 	  http://archives.postgresql.org/pgsql-hackers/2006-12/msg00876.php

* Add Globally/Universally Unique Identifier (GUID/UUID)
>   http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php

existing TODO items, and re-add a TODO item for an "estimated
count" capability.

< 		o Fix memory leak from exceptions
<
< 		  http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php
<
< * Allow constraint_exclusion to work for UNIONs like it does for
<   inheritance, allow it to work for UPDATE and DELETE statements, and allow
<   it to be used for all statements with little performance impact
<
< * Add estimated_count(*) to return an estimate of COUNT(*)
<
<   This would use the planner ANALYZE statistics to return an estimated
<   count.
<   http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php

> 	  http://archives.postgresql.org/pgsql-hackers/2007-01/msg00291.php

> 	o Fix transaction restriction checks for CREATE DATABASE and
> 	  other commands
>
> 	  http://archives.postgresql.org/pgsql-hackers/2007-01/msg00133.php

> 	  http://archives.postgresql.org/pgsql-hackers/2007-01/msg00184.php

> 	o Extend timezone code to allow 64-bit values so we can
> 	  represent years beyond 2038
>
> 	  http://archives.postgresql.org/pgsql-hackers/2006-09/msg01363.php
>

> * Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h and
>   consider making it more configurable in future releases

>
> * Improve merge join performance by allowing mark/restore of
>   tuple sources
>
>   http://archives.postgresql.org/pgsql-hackers/2007-01/msg00096.php
>

> * -Add ability to monitor the use of temporary sort files

< * Allow the creation of indexes with mixed ascending/descending
> * -Allow the creation of indexes with mixed ascending/descending
<
<   This is possible now by creating an operator class with reversed sort
<   operators.  One complexity is that NULLs would then appear at the start
<   of the result set, and this might affect certain sort types, like
<   merge join.
<

< * %Allow the identifier length to be increased via a configure option

< * Improve the MONEY data type
> * -Make 64-bit version of the MONEY data type
> * Add locale-aware MONEY type, and support multiple currencies
<   Change the MONEY data type to use DECIMAL internally, with special
<   locale-aware output formatting.
<   http://archives.postgresql.org/pgsql-hackers/2006-09/msg01107.php

> * -Allow user-defined types to accept 'typmod' parameters

>
> * Make consistent use of long/short command options --- pg_ctl needs
>   long ones, pg_config doesn't have short ones, postgres doesn't have
>   enough long ones, etc.

> 	o Consider parsing the -c string into individual queries so each
> 	  is run in its own transaction
>
> 	o Consider disallowing multiple queries in PQexec() as an
> 	  additional barrier to SQL injection attacks

< * Allow CREATE INDEX to take an additional parameter for use with
<   special index types

< * Allow inherited tables to inherit index, UNIQUE constraint, and primary
<   key, foreign key
< * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
<   inherited table:  INSERT INTO inherit_table (unique_index_col) VALUES
<   (dup) should fail
<
<   The main difficulty with this item is the problem of creating an index
<   that can span more than one table.
<
< * Allow SELECT ... FOR UPDATE on inherited tables
> * Inheritance
>
> 	o Allow inherited tables to inherit indexes, UNIQUE constraints,
> 	  and primary/foreign keys
> 	o Honor UNIQUE INDEX on base column in INSERTs/UPDATEs
> 	  on inherited table, e.g.  INSERT INTO inherit_table
> 	  (unique_index_col) VALUES (dup) should fail
>
> 	  The main difficulty with this item is the problem of
> 	  creating an index that can span multiple tables.
>
> 	o Allow SELECT ... FOR UPDATE on inherited tables
>
>
>

> * -Allow the pg_xlog directory location to be specified during initdb

>   http://archives.postgresql.org/pgsql-hackers/2006-12/msg01213.php

< * Add a GUC to control whether BEGIN inside a transcation should abort
<   the transaction.

< * Move some /contrib modules out to their own project sites
<
<   Particularly, move GPL-licensed /contrib/userlock and
<   /contrib/dbmirror/clean_pending.pl.
<

< 	o Improve xid wraparound detection by recording per-table rather
< 	  than per-database

<   While PostgreSQL clients runs fine limited-resource environments, the
>   While PostgreSQL clients runs fine in limited-resource environments, the

< * Make CLUSTER preserve recently-dead tuples per MVCC requirements
> 	o Make CLUSTER preserve recently-dead tuples per MVCC requirements