|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Tue Nov27 16:22:52 EST 2001 |
| 3 | +Last updated:Wed Nov28 00:44:46 EST 2001 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
6 | 6 |
|
@@ -179,6 +179,8 @@ COMMANDS |
179 | 179 | o ALTER TABLE ADD PRIMARY KEY (Christopher Kings-Lynne) |
180 | 180 | o ALTER TABLE ADD UNIQUE (Christopher Kings-Lynne) |
181 | 181 | o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence |
| 182 | +o ALTER TABLE ADD COLUMN column SET DEFAULT should fill existing |
| 183 | + rows with DEFAULT value or allow NULLs in existing rows |
182 | 184 | * CLUSTER |
183 | 185 | o cluster all tables at once |
184 | 186 | o prevent lose of indexes, permissions, inheritance (Bruce) |
|