TODO list for PostgreSQL
========================
-Last updated: Wed Nov 6 00:56:27 EST 2002
+Last updated: Tue Dec 24 17:06:43 EST 2002
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
o allow replication over unreliable or non-persistent links
o http://gborg.postgresql.org/project/pgreplication/projdisplay.php
* Point-in-time data recovery using backup and write-ahead log
+* Create native Win32 port [win32]
Reporting
* Add function to return compressed length of TOAST data values (Tom)
* Allow INET subnet tests using non-constants
* Add now("transaction|statement|clock") functionality
+* -Add GUC variables to control floating number output digits (Pedro Ferreira)
+* Have sequence dependency track use of DEFAULT sequences, seqname.nextval
* CONVERSION
o Allow better handling of numeric constants, type conversion
* Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
* Allow REINDEX to rebuild all indexes, remove /contrib/reindex
* Make a transaction-safe TRUNCATE
+* Fix SELECT ... INTO and CREATE TABLE AS to have appopriate OID column
+* Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY
+
* ALTER
o ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT
o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because
of the item above
o Add ALTER TABLE tab SET WITHOUT OIDS
+ * Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values
* CLUSTER
o Automatically maintain clustering on a table
o Allow CLUSTER to cluster all tables, remove clusterdb
* COPY
- o Allow psql \copy to specify column names
o Allow dump/load of CSV format
o Allow COPY to report error lines and continue; optionally
allow error codes to be specified; requires savepoints or can
* CURSOR
o Allow BINARY option to SELECT, just like DECLARE
- o MOVE 0 should not move to end of cursor (Bruce)
+ o -MOVE 0 should not move to end of cursor (Bruce)
o Allow UPDATE/DELETE WHERE CURRENT OF cursor using per-cursor tid
stored in the backend
o Prevent DROP of table being referenced by our own open cursor
RULE cases (Philip)
* SHOW/SET
- o Add SET REAL_FORMAT and SET DOUBLE_PRECISION_FORMAT using printf args
o Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
ANALYZE, and CLUSTER
o Add SET SCHEMA
* Allow psql to show transaction status if backend protocol changes made
* Add XML interface: psql, pg_dump, COPY, separate server (?)
-* Add schema, cast, and conversion backslash commands to psql
+* -Add schema, cast, and conversion backslash commands to psql (Christopher)
* Allow pg_dump to dump a specific schema
* Allow psql to do table completion for SELECT * FROM schema_part and
table completion for SELECT * FROM schema_name.
o Add SQLSTATE
o fix handling of DB attributes that are arrays
+* Python
+ o Allow users to register their own types with _pg
+ o Allow SELECT to return a dictionary of dictionaries
+ o Allow COPY BINARY FROM
+
Referential Integrity
=====================
in array
* Allow DEFERRABLE UNIQUE constraints
* Allow triggers to be disabled [trigger]
-* Support statement-level triggers and triggers on columns (Neil)
+* -Support statement-level triggers (Neil)
+* Support triggers on columns (Neil)
Dependency Checking
============
* Overhaul bufmgr/lockmgr/transaction manager
-* Allow savepoints / nested transactions [transactions]
+* Allow savepoints / nested transactions [transactions] (Bruce)
Exotic Features
===============
-* Add sql3 recursive unions
+* Add SQL99 WITH clause to SELECT (Tom, Fernando)
+* Add SQL99 WITH RECURSIVE to SELECT (Tom, Fernando)
* Add the concept of dataspaces/tablespaces [tablespaces]
* Allow queries across multiple databases [crossdb]
* Add pre-parsing phase that converts non-ANSI features to supported features
* Missing optimizer selectivities for date, r-tree, etc. [optimizer]
* Allow ORDER BY ... LIMIT to select top values without sort or index
using a sequential scan for highest/lowest values (Oleg)
-* Inline simple SQL functions to avoid overhead (Tom)
+* -Inline simple SQL functions to avoid overhead (Tom)
* Precompile SQL functions to avoid overhead (Neil)
* Add utility to compute accurate random_page_cost value
* Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
* Use mmap() rather than SYSV shared memory or to write WAL files (?) [mmap]
* Improve caching of attribute offsets when NULLs exist in the row
+* Wire Protocol Changes
+ o Show transaction status in psql
+ o Allow binding of query parameters, support for prepared queries
+ o Add optional textual message to NOTIFY
+ o Remove hard-coded limits on user/db/password names
+ o Remove unused elements of startup packet (unused, tty, passlength)
+ o Fix COPY/fastpath protocol?
+ o Replication support?
+ o Error codes
+ o Dynamic character set handling
+ o Special passing of binary values in platform-neutral format (bytea?)
+ o ecpg improvements?
+ o Add decoded type, length, precision
+ o Compression?
+
Source Code
===========
* Remove warnings created by -Wcast-align
* Move platform-specific ps status display info from ps_status.c to ports
* Modify regression tests to prevent failures do to minor numeric rounding
-* Add OpenBSD's getpeereid() call for local socket authentication (Bruce)
+* -Add OpenBSD's getpeereid() call for local socket authentication
* Improve access-permissions check on data directory in Cygwin (Tom)
* Add --port flag to regression tests
* Add documentation for perl, including mention of DBI/DBD perl location
* Better document ability to build only certain interfaces (Marc)
* Remove or relicense modules that are not under the BSD license, if possible
* Remove memory/file descriptor freeing befor elog(ERROR) (Bruce)
-* Create native Win32 port [win32]
* Acquire lock on a relation before building a relcache entry for it
-* Move dbmirror and rserv from /contrib to gborg.postgresql.org
+* Research interaction of setitimer() and sleep() used by statement_timeout
---------------------------------------------------------------------------
--------------------------------------
* Barry is Barry Lind <barry@xythos.com>
* Billy is Billy G. Allie <Bill.Allie@mug.org>
-* Bruce is Bruce Momjian <pgman@candle.pha.pa.us>
-* Christopher is Christopher Kings-Lynne <chriskl@familyhealth.com.au>
-* D'Arcy is D'Arcy J.M. Cain <darcy@druid.net>
+* Bruce is Bruce Momjian <pgman@candle.pha.pa.us> of Software Research Assoc.
+* 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.
* Dave is Dave Cramer <dave@fastcrypt.com>
* Edmund is Edmund Mergl <E.Mergl@bawue.de>
-* Gavin Sherry <swm@linuxworld.com.au>
+* Fernando Nasser <fnasser@redhat.com> of Red Hat
+* Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering
* Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
* Karel is Karel Zak <zakkr@zf.jcu.cz>
-* Jan is Jan Wieck <wieck@sapserv.debis.de>
-* Liam is Liam Stewart <liams@redhat.com>
-* Marc is Marc Fournier <scrappy@hub.org>
+* Jan is Jan Wieck <JanWieck@Yahoo.com> of PeerDirect Corp.
+* Liam is Liam Stewart <liams@redhat.com> of Red Hat
+* Marc is Marc Fournier <scrappy@hub.org> of PostgreSQL, Inc.
* Mark is Mark Hollomon <mhh@mindspring.com>
-* Marko is Marko Kreen <marko@l-t.ee>
-* Michael is Michael Meskes <meskes@postgresql.org>
+* Michael is Michael Meskes <meskes@postgresql.org> of Credativ
* Neil is Neil Conway <neilc@samurai.com>
* Oleg is Oleg Bartunov <oleg@sai.msu.su>
-* Peter M is Peter T Mount <peter@retep.org.uk>
+* Peter M is Peter T Mount <peter@retep.org.uk> of Retep Software
* Peter E is Peter Eisentraut <peter_e@gmx.net>
-* Philip is Philip Warner <pjw@rhyme.com.au>
+* Philip is Philip Warner <pjw@rhyme.com.au> of Albatross Consulting Pty. Ltd.
* Rod is Rod Taylor <rbt@zort.ca>
* Ross is Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
-* Ryan is Ryan Bradetich <rbrad@hpb50023.boi.hp.com>
* Stephan is Stephan Szabo <sszabo@megazone23.bigpanda.com>
-* Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp>
-* Thomas is Thomas Lockhart <lockhart@fourpalms.org>
-* Tom is Tom Lane <tgl@sss.pgh.pa.us>
-* TomH is Tom I Helbekkmo <tih@Hamartun.Priv.no>
-* Vadim is Vadim B. Mikheev <vadim4o@email.com>
+* Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp> of Software Research Assoc.
+* Thomas is Thomas Lockhart <lockhart@fourpalms.org> of Jet Propulsion Labratory
+* Tom is Tom Lane <tgl@sss.pgh.pa.us> of Red Hat
+* Vadim is Vadim B. Mikheev <vadim4o@email.com> of Sector Data