diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-02 16:21:30 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-02 16:21:30 +0000 |
| commit | e8b83190a173aece0c15b72fabe1a2227e294337 (patch) | |
| tree | ee8f7dff0af5a0f351c0867dd5441623ed3bddc7 | |
| parent | 75803a01634a778b0f0efe11364cbf453a981e6a (diff) | |
| download | postgresql-e8b83190a173aece0c15b72fabe1a2227e294337.tar.gz postgresql-e8b83190a173aece0c15b72fabe1a2227e294337.zip | |
Updated from Tom:
< o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher Kings-Lynne)
< o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence
> o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher)
200a200,201
> o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because
> of the item above
232c233
< o -Disallow missing columns in INSERT ... VALUES, per ANSI
> o -Disallow missing columns in INSERT ... (col) VALUES, per ANSI
335,336d335
< * Have SERIAL generate non-colliding sequence names when we have
< auto-destruction
| -rw-r--r-- | doc/TODO | 11 |
1 files changed, 5 insertions, 6 deletions
@@ -1,6 +1,6 @@ TODO list for PostgreSQL ======================== -Last updated: Mon Sep 2 11:30:39 EDT 2002 +Last updated: Mon Sep 2 12:20:47 EDT 2002 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -194,10 +194,11 @@ Commands o -Add ALTER TABLE DROP non-CHECK CONSTRAINT o -ALTER TABLE ADD PRIMARY KEY (Christopher) o -ALTER TABLE ADD UNIQUE (Christopher) - o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher Kings-Lynne) - o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence + o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher) 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 OWNER change all dependant objects like indexes o Add ALTER TABLE tab SET WITHOUT OIDS @@ -229,7 +230,7 @@ Commands o Allow INSERT/UPDATE of system-generated oid value for a row o Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) o -Allow INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...) - o -Disallow missing columns in INSERT ... VALUES, per ANSI + o -Disallow missing columns in INSERT ... (col) VALUES, per ANSI o Allow INSERT/UPDATE ... RETURNING new.col or old.col; handle RULE cases (Philip) @@ -332,8 +333,6 @@ Dependency Checking depend_sysrelid, depend_oid, name * -Auto-destroy sequence on DROP of table with SERIAL; perhaps a separate SERIAL type -* Have SERIAL generate non-colliding sequence names when we have - auto-destruction * -Prevent column dropping if column is used by foreign key * -Propagate column or table renaming to foreign key constraints * -Automatically drop constraints/functions when object is dropped |