diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-05-05 14:36:20 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-05-05 14:36:20 +0000 |
| commit | a4ab5bae4280ce40d4b155d29d91ae2ea04f7851 (patch) | |
| tree | 019392e73e6636eef466acb9ee16e5ad05bae46a | |
| parent | 3b8151a5eee1796837a2949cf27e4894bfa1d6ff (diff) | |
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
| -rw-r--r-- | doc/TODO | 10 |
1 files changed, 4 insertions, 6 deletions
@@ -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 |