TODO list for PostgreSQL

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

Last updated:Mon Feb21 19:58:12 EST 2000

Last updated:Tue Feb22 09:07:16 EST 2000

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

* -Add index on NUMERIC/DECIMAL type(Jan)

* -Make Absolutetime/Relativetime int4 because time_t can be int8 on some ports

* Functions returning sets don't really work right[function]

*-Make type equivalency apply to aggregates

* Make type equivalency apply to aggregates(Peter E.)

VIEWS

* 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 WHERE restriction on ctid(Hiroshi)

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

* -Document/trigger/rule so changes to pg_shadow recreate pg_pwd [pg_shadow]

* -Document/trigger/rule so changes to pg_shadow recreate pg_pwd

[pg_shadow](Peter E.)

* Missing optimizer selectivities for date, r-tree, etc. [optimizer]

* -Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup

* Overhaul bufmgr/lockmgr/transaction manager

* improve dynamic memory allocation by introducing tuple-context memory

allocation [memory]

* -fix memory leak in cache code when non-existant table is referenced

In WHERE tab1.x=3 AND tab1.x=tab2.y, add tab2.y=3

* In WHERE tab1.x=3 AND tab1.x=tab2.y, add tab2.y=3

* -pass atttypmod through parser in more cases [atttypmod]

* -remove duplicate type in/out functions for disk and net

* Allow persistent backends [persistent]