Bracketed items "[]" have more detail.

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

Last updated:Wed Nov 1022:59:04 EST 2004

Last updated:Wed Nov 1023:36:48 EST 2004

The most recent version of this document can be viewed at the PostgreSQL web

site, http://www.PostgreSQL.org.

* Prevent INET cast to CIDR if the unmasked bits are not zero, or

zero the bits

* ARRAYS

o Allow NULLs in arrays

o Allow MIN()/MAX() on arrays

* Allow accurate statistics to be collected on indexes with more than

one column or expression indexes, perhaps using per-index statistics

* Add fillfactor to control reserved free space during index creation

Commands

========

To do this, determine the ideal cluster index for each system

table and set the cluster setting during initdb.

* COPY

o Allow COPY to report error lines and continue

o Have COPY return the number of rows loaded/unloaded (?)

o Allow COPY to optionally include column headings in the first line

* CURSOR

o Allow UPDATE/DELETE WHERE CURRENT OF cursor

Because WITH HOLD cursors exist outside transactions, this allows

them to be listed so they can be closed.

* INSERT

o Allow INSERT/UPDATE of the system-generated oid value for a row

o Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)

One complication is how to handle rules that run as part of

the insert.

* SHOW/SET

o Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM

ANALYZE, and CLUSTER

This requires a checking function to be called after the server

configuration file is read.

* SERVER-SIDE LANGUAGES

o Allow PL/PgSQL's RAISE function to take expressions (?)

o Add CSV output format

* ECPG (?)

* ECPG

o Docs

Document differences between ecpg and the SQL standard and

* Remove Win32 rename/unlink looping if unnecessary

* Remove kerberos4 from source tree?

* Win32

o Remove per-backend parameter file and move into shared memory

o Remove configure.in check for link failure when cause is found

o Re-enable timezone output on log_line_prefix '%t' when a

shorter timezone string is available

* Wire Protocol Changes

o Allow dynamic character set handling

o Add decoded type, length, precision