From 39f987c568fcd54d82d7262f2a7273b7496ff205 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 3 Jan 2001 06:56:52 +0000 Subject: [PATCH] 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) --- doc/TODO | 50 ++++++++++++++++++++++++++------------------------ 1 file changed, 26 insertions(+), 24 deletions(-) diff --git a/doc/TODO b/doc/TODO index be012f1b46..03d5c4b221 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 -- 2.40.0