TODO list for PostgreSQL

========================

Last updated:Tue Jan2 21:23:11 EST 2001

Last updated:Wed Jan3 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.

* 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

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

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

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

* -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

* 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

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

* 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)

* -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

* 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

* -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

* 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