Update TODO list.

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.311
diff -r1.311 TODO
3c3
< Last updated:		Tue Jan  2 21:23:11 EST 2001
---
> Last updated:		Wed Jan  3 01:56:41 EST 2001
10c10
< A dash(-) marks changes that will appear in the upcoming 7.1 release.
---
> A dash (-) marks changes that will appear in the upcoming 7.1 release.
23c23
< * -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas)
---
> * -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME (Thomas)
35c35
< * -Views containing aggregates sometimes fail(Jan)
---
> * -Views containing aggregates sometimes fail (Jan)
37,38c37,38
<   duplicates(inherit)
< * -Disallow LOCK on view(Mark Hollomon)
---
>   duplicates (inherit)
> * -Disallow LOCK on view (Mark Hollomon)
58,60c58,60
< * -Add OUTER joins, left and right[outer](Tom, Thomas)
< * -Allow long tuples by chaining or auto-storing outside db (TOAST)(Jan)
< * Fix memory leak for expressions[memory](Tom?)
---
> * -Add OUTER joins, left and right[outer] (Tom, Thomas)
> * -Allow long tuples by chaining or auto-storing outside db (TOAST) (Jan)
> * Fix memory leak for expressions[memory] (Tom?)
70c70
< * Allow row re-use without vacuum(Vadim)
---
> * Allow row re-use without vacuum (Vadim)
74c74
< * More access control over who can create tables and use locks(Karel)
---
> * More access control over who can create tables and use locks (Karel)
92c92
< 	o -Fix large object mapping scheme, own typeid or reltype(Peter)
---
> 	o -Fix large object mapping scheme, own typeid or reltype (Peter)
97c97
< * Fix improper masking of some inet/cidr types [cidr]
---
> * -Fix improper masking of some inet/cidr types [cidr]
113c113
< * Get BIT type working
---
> * -Get BIT type working
119c119
< * Update macaddr manufacturer numbers, or remove the function macaddr_manuf()
---
> * -Update macaddr manufacturer numbers, or remove the function macaddr_manuf()
147c147
< * -Add ALTER TABLE ALTER COLUMN feature(Peter E)
---
> * -Add ALTER TABLE ALTER COLUMN feature (Peter E)
157c157
< * Auto-destroy sequence on DROP of table with SERIAL(Ryan)
---
> * Auto-destroy sequence on DROP of table with SERIAL (Ryan)
166a167
> * Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
172d172
< * Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
176c176
< * Make NULL's come out at the beginning or end depending on the
---
> * Make NULL's come out at the beginning or end depending on the
220c220
< * Certain indexes will not shrink, i.e. oid indexes with many inserts(Vadim)
---
> * Certain indexes will not shrink, i.e. oid indexes with many inserts (Vadim)
226c226
<   with after-row images(Vadim) [logging](Vadim)
---
>   with after-row images (Vadim) [logging]
232c232
< * -Redesign the function call interface to handle NULLs better[function](Tom)
---
> * -Redesign the function call interface to handle NULLs better[function] (Tom)
239c239
< * Encrpyt passwords in pg_shadow table using MD5(Vince)
---
> * Encrpyt passwords in pg_shadow table using MD5 (Vince)
298a299,300
> * Create a transaction processor to aid in persistent connections and
>   connection pooling
307c309
< * Remove SET KSQO option now that OR processing is improved(Tom)
---
> * Remove SET KSQO option now that OR processing is improved (Tom)

1 files changed, 26 insertions, 24 deletions

diff --git a/doc/TODO b/doc/TODO
index be012f1b46e..03d5c4b2218 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -1,13 +1,13 @@
 TODO list for PostgreSQL
 ========================
-Last updated:		Tue Jan  2 21:23:11 EST 2001
+Last updated:		Wed Jan  3 01:56:41 EST 2001
 
 Current maintainer:	Bruce Momjian (pgman@candle.pha.pa.us)
 
 The most recent version of this document can be viewed at
 the PostgreSQL web site, http://www.PostgreSQL.org.
 
-A dash(-) marks changes that will appear in the upcoming 7.1 release.
+A dash (-) marks changes that will appear in the upcoming 7.1 release.
 
 Names in brackets "[]" indicate more detailed information is available in
 the directory pgsql/doc/TODO.detail/ under that name.
@@ -20,7 +20,7 @@ PARSER
 
 * SELECT pg_class FROM pg_class generates strange error
 * Alter TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT
-* -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas)
+* -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME (Thomas)
 * -SELECT foo UNION SELECT foo is incorrectly simplified to SELECT foo
 * Unique index on base column not honored on inserts from inherited table
   INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail
@@ -32,10 +32,10 @@ PARSER
 
 VIEWS
 
-* -Views containing aggregates sometimes fail(Jan)
+* -Views containing aggregates sometimes fail (Jan)
 * Creating view and inheriting the view causes view* to show
-  duplicates(inherit) 
-* -Disallow LOCK on view(Mark Hollomon)
+  duplicates (inherit) 
+* -Disallow LOCK on view (Mark Hollomon)
 
 MISC
 
@@ -55,9 +55,9 @@ ENHANCEMENTS
 
 URGENT
 
-* -Add OUTER joins, left and right[outer](Tom, Thomas)
-* -Allow long tuples by chaining or auto-storing outside db (TOAST)(Jan)
-* Fix memory leak for expressions[memory](Tom?) 
+* -Add OUTER joins, left and right[outer] (Tom, Thomas)
+* -Allow long tuples by chaining or auto-storing outside db (TOAST) (Jan)
+* Fix memory leak for expressions[memory] (Tom?) 
 * Add replication of distributed databases [replication]
 	o automatic fallover
 	o load balancing
@@ -67,11 +67,11 @@ URGENT
 	o sample implementation in contrib/rserv
 	o queries across databases or servers (two-phase commit)
 * Point-in-time data recovery using backup and write-ahead log
-* Allow row re-use without vacuum(Vadim)
+* Allow row re-use without vacuum (Vadim)
 
 ADMIN
 
-* More access control over who can create tables and use locks(Karel)
+* More access control over who can create tables and use locks (Karel)
 * -Test syslog functionality
 * Convert remaining fprintf(stderr,...) to elog()
 * Allow elog() to return error codes, module name, file name, line
@@ -89,12 +89,12 @@ TYPES
 * -Add STDDEV/VARIANCE() function for standard deviation computation/variance
 * -Allow compression of large fields or a compressed field type
 * -Large objects
-	o -Fix large object mapping scheme, own typeid or reltype(Peter)
+	o -Fix large object mapping scheme, own typeid or reltype (Peter)
 	o -Not to stuff everything as files in a single directory, hash dirs
 	o -Allow large object vacuuming
 	o -Tables that start with xinv confused to be large objects
 * Add IPv6 capability to INET/CIDR types
-* Fix improper masking of some inet/cidr types [cidr]
+* -Fix improper masking of some inet/cidr types [cidr]
 * Make a separate SERIAL type?
 * Store binary-compatible type information in the system
 * Add support for & operator
@@ -110,13 +110,13 @@ TYPES
 * Functions returning sets don't really work right[function]
 * -Add hash for int8 (Tom)
 * SELECT col FROM tab WHERE numeric_col = 10.1 fails
-* Get BIT type working
+* -Get BIT type working
 * Allow better handling of numeric constants, type conversion [typeconv]
 * Support multiple simultaneous character sets, per SQL92
 * Reject character sequences those are not valid in their charset
 * Make functions more multi-byte aware, i.e. trim()
 * Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes
-* Update macaddr manufacturer numbers, or remove the function macaddr_manuf()
+* -Update macaddr manufacturer numbers, or remove the function macaddr_manuf()
 * Add btree index support for reltime, tinterval, regproc, bit, varbit
 * Add rtree index support for line, lseg, path, point
 * Make binary/file in/out interface for TOAST columns
@@ -144,7 +144,7 @@ INDEXES
 COMMANDS
 
 * ALTER TABLE ADD COLUMN to inherited table put column in wrong place [inherit]
-* -Add ALTER TABLE ALTER COLUMN feature(Peter E)
+* -Add ALTER TABLE ALTER COLUMN feature (Peter E)
 * Add ALTER TABLE DROP COLUMN feature [drop]
 * Add ALTER TABLE command to change table ownership (Mark H)
 * Add ALTER FUNCTION 
@@ -154,7 +154,7 @@ COMMANDS
 * Allow CLUSTER on all tables at once, and improve CLUSTER, loses NOT
 	NULL specification, indexes, permissions, etc on table
 * Add SIMILAR TO to allow character classes, 'pg_[a-c]%'
-* Auto-destroy sequence on DROP of table with SERIAL(Ryan)
+* Auto-destroy sequence on DROP of table with SERIAL (Ryan)
 * Allow LOCK TABLE tab1, tab2, tab3 so all tables locked in unison [lock]
 * Allow INSERT/UPDATE of system-generated oid value for a row
 * -Allow ESCAPE '\' at the end of LIKE for ANSI compliance (Thomas)
@@ -164,16 +164,16 @@ COMMANDS
 * -Support UNION/INTERSECT/EXCEPT in sub-selects
 * -Allow DELETE and UPDATE to use inheritance
 * Allow INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...)
+* Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
 * Allow BINARY option to SELECT, like we do with DECLARE
 * MOVE 0 should not move to end of cursor
 * Overhaul ACL (access control) code
 * Allow ORDER BY...LIMIT in INSERT INTO ... SELECT
 * Add SHOW command to display locks
-* Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
 
 CLIENTS
 
-* Make NULL's come out at the beginning or end depending on the 
+* Make NULL's come out at the beginning or end depending on the
   ORDER BY direction
 * Update reltuples from COPY command
 * Allow COPY to specify column names
@@ -217,26 +217,26 @@ MISC
 * Create a background process for each database that runs while
   database is idle, finding superceeded rows, gathering stats and vacuuming
 * Add UNIQUE capability to non-btree indexes
-* Certain indexes will not shrink, i.e. oid indexes with many inserts(Vadim)
+* Certain indexes will not shrink, i.e. oid indexes with many inserts (Vadim)
 * Restore unused oid's on backend exit if no one else has gotten oids
 * Have UPDATE/DELETE clean out indexes
 * Allow cursors to be DECLAREd/OPENed/CLOSEed outside transactions
 * Allow DELETE WHERE CURRENT OF cursor
 * -Transaction log, so re-do log can be on a separate disk by
-  with after-row images(Vadim) [logging](Vadim)
+  with after-row images (Vadim) [logging]
 * Populate backend status area and write program to dump status data
 * Make oid use unsigned int more reliably, pg_atoi()
 * Put sort files in their own directory
 * Allow autocommit so always in a transaction block
 * Show location of syntax error in query [yacc]
-* -Redesign the function call interface to handle NULLs better[function](Tom)
+* -Redesign the function call interface to handle NULLs better[function] (Tom)
 * Missing optimizer selectivities for date, r-tree, etc. [optimizer]
 * Overhaul bufmgr/lockmgr/transaction manager
 * -redesign UNION structures to have separarate target lists
 * -Allow multi-level query trees for INSERT INTO ... SELECT
 * Use IPC_EXCL when creating shared memory and semaphores
 * have pg_upgrade use pg_ctl to stop/start postmaster
-* Encrpyt passwords in pg_shadow table using MD5(Vince)
+* Encrpyt passwords in pg_shadow table using MD5 (Vince)
 * Use flock() to prevent multiple postmasters on the same port [flock]
 * Allow Java server-side programming
 
@@ -296,6 +296,8 @@ MISC
 * -BSD/OS does not support locale because there is no LC_MESSAGES (Bruce)
 * Add connection pooling [pool]
 * Allow persistent backends [persistent]
+* Create a transaction processor to aid in persistent connections and
+  connection pooling
 * Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
   ANALYZE, and CLUSTER
 
@@ -304,7 +306,7 @@ SOURCE CODE
 * Add use of 'const' for variables in source tree
 * -Fix C optimizer problem where fmgr_ptr calls return different types (Tom)
 * Does Mariposa source contain any other bug fixes?
-* Remove SET KSQO option now that OR processing is improved(Tom)
+* Remove SET KSQO option now that OR processing is improved (Tom)
 * -Use macros to define NT open() file parameters, remove NT-specific defines
 * -Change CURRENT to OLD internally for rules (Bruce)
 * replace the use of fprint(stderr, ...) with elog() in backend code