From a4ab5bae4280ce40d4b155d29d91ae2ea04f7851 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 5 May 2004 14:36:20 +0000 Subject: [PATCH] Done: 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 -Allow ALTER TABLE to modify column lengths and change to binary compatible types Remove: o Allow columns to be reordered using ALTER ... POSITION i col1 [,col2]; have SELECT * and INSERT honor such ordering --- doc/TODO | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/doc/TODO b/doc/TODO index ab8c23e5bb..4a298e4bd4 100644 --- a/doc/TODO +++ b/doc/TODO @@ -1,6 +1,6 @@ TODO list for PostgreSQL ======================== -Last updated: Sun May 2 08:27:42 EDT 2004 +Last updated: Wed May 5 10:32:23 EDT 2004 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -189,15 +189,13 @@ Commands * 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 -- 2.40.0