TODO list for PostgreSQL

========================

Last updated:Sun May2 08:27:42 EDT 2004

Last updated:Wed May5 10:32:23 EDT 2004

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

* Add a session mode to warn about non-standard SQL usage

* ALTER

o ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT

o ALTER TABLE ADD COLUMN column DEFAULT should fill existing

o-ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT

o-ALTER TABLE ADD COLUMN column DEFAULT should fill existing

rows with DEFAULT value

o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because

of the item above

o Have ALTER TABLE rename SERIAL sequences

o Allow columns to be reordered using ALTER ... POSITION i col1 [,col2];

have SELECT * and INSERT honor such ordering

o Allow ALTER TABLE to modify column lengths and change to binary

o -Allow ALTER TABLE to modify column lengths and change to binary

compatible types

o Add ALTER DATABASE ... OWNER TO newowner

o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME