Done:

[postgresql] / doc / TODO

diff --git a/doc/TODO b/doc/TODO
index 4a79986b64bb25ca89cf410b8beec04e17c8970a..6c8fe322667520dbb8490fe2f51c879c9fd86525 100644 (file)
--- a/doc/TODO
+++ b/doc/TODO
@@ -2,7 +2,7 @@
 PostgreSQL TODO List
 ====================
 Current maintainer:    Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated:          Mon Apr 24 20:06:13 EDT 2006
+Last updated:          Sat Apr 29 22:10:37 EDT 2006
 
 The most recent version of this document can be viewed at
 http://www.postgresql.org/docs/faqs.TODO.html.
@@ -54,6 +54,8 @@ Administration
 
   This would allow administrators to see more detailed information from
   specific sections of the backend, e.g. checkpoints, autovacuum, etc.
+  Another idea is to allow separate configuration files for each module,
+  or allow arbitrary SET commands to be passed to them.
 
 * -Re-enable the GUC full_page_writes in 8.2 when reliability issues have
   been addressed
@@ -79,7 +81,7 @@ Administration
          Currently, if a variable is commented out, it keeps the
          previous uncommented value until a server restarted.
 
-       o %Allow per-database permissions to be set via GRANT
+       o -Allow per-database permissions to be set via GRANT
 
          Allow database connection checks based on GRANT rules in
          addition to the existing access checks in pg_hba.conf.
@@ -198,7 +200,7 @@ Data Types
   The positive modulus result returned by NUMERICs might be considered
   inaccurate, in one sense.
 
-* %Disallow changing default expression of a SERIAL column
+* %Disallow changing default expression of a SERIAL column?
 * %Disallow ALTER SEQUENCE changes for SERIAL sequences because pg_dump
   does not dump the changes
 * Fix data types where equality comparison isn't intuitive, e.g. box
@@ -295,7 +297,7 @@ Functions
 =========
 
 * Allow INET subnet tests using non-constants to be indexed
-* Add transaction_timestamp(), statement_timestamp(), clock_timestamp()
+* -Add transaction_timestamp(), statement_timestamp(), clock_timestamp()
   functionality
 
   Current CURRENT_TIMESTAMP returns the start time of the current
@@ -398,6 +400,8 @@ SQL Commands
   manually or automatically when statistics for execute parameters
   differ dramatically from those used during planning.
 
+* Invalidate prepared queries, like INSERT, when the table definition
+  is altered
 * Allow LISTEN/NOTIFY to store info in memory rather than tables?
 
   Currently LISTEN/NOTIFY information is stored in pg_listener. Storing
@@ -499,13 +503,11 @@ SQL Commands
          Currently non-global system tables must be in the default database
          tablespace. Global system tables can never be moved.
 
-       o %Prevent child tables from altering or dropping constraints 
-          like CHECK that were inherited from the parent table
        o Prevent parent tables from altering or dropping constraints
-         like CHECK that are inherited by child tables
-
-         Dropping constraints should only be possible with CASCADE.
-
+         like CHECK that are inherited by child tables unless CASCADE
+         is used
+       o %Prevent child tables from altering or dropping constraints
+          like CHECK that were inherited from the parent table
        o Have ALTER INDEX update the name of a constraint using that index
        o Add ALTER TABLE RENAME CONSTRAINT, update index name also
 
@@ -1091,7 +1093,7 @@ Write-Ahead Log
   entire rows?
 * Allow the pg_xlog directory location to be specified during initdb
   with a symlink back to the /data location
-* Allow WAL information to recover corrupted pg_controldata
+* -Allow WAL information to recover corrupted pg_controldata
 * Find a way to reduce rotational delay when repeatedly writing
   last WAL page