|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Thu Jan 403:24:53 EST 2001 |
| 3 | +Last updated:Thu Jan 413:51:05 EST 2001 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
6 | 6 |
|
|
46 | 46 | * -SELECT ... UNION ... ORDER BY fails when sort expr not in result list |
47 | 47 | * -SELECT ... UNION ... GROUP BY fails if column types disagree, no type |
48 | 48 | promotion occurs |
49 | | -*-Modification of pg_class can happen while table in use by |
| 49 | +* Modification of pg_class can happen while table in use by |
50 | 50 | another backend. Might lead to MVCC inside of syscache |
51 | 51 | * Permission to DELETE table allows UPDATE also |
52 | 52 |
|
@@ -187,13 +187,11 @@ CLIENTS |
187 | 187 | REFERENTIAL INTEGRITY |
188 | 188 |
|
189 | 189 | * Add MATCH PARTIAL referential integrity |
190 | | -* Foreign key does not check that columns referenced form a primary key |
191 | | - or constrained by UNIQUE |
192 | 190 | * Check that primary key exists at foreign key definition time |
193 | 191 | * Prevent column dropping if column is used by foreign key |
194 | 192 | * Propagate column or table renaming to foreign key constraints |
195 | 193 | * -Emit a warning at foreign key creation time if no UNIQUE index |
196 | | - exists on referenced primary key attributes (Tom) |
| 194 | + exists on referenced primary key attributes |
197 | 195 | * Add deferred trigger queue file (Jan) |
198 | 196 | * Allow oid to act as a foreign key |
199 | 197 | * Implement dirty reads and use them in RI triggers |
|