TODO list for PostgreSQL
========================
-Last updated: Tue Dec 3 17:10:42 EST 2002
+Last updated: Tue Dec 24 17:06:43 EST 2002
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
* 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 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
* 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.
Exotic Features
===============
-* Add SQL99 WITH clause to SELECT
-* Add SQL99 WITH RECURSIVE to SELECT
+* 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
* 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
===========
--------------------------------------
* 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
projects / postgresql / blobdiff