TODO list for PostgreSQL

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

Last updated:Tue Jun 1212:18:18 EDT 2001

Last updated:Tue Jun 1214:15:23 EDT 2001

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

* -Permission to DELETE table also allows UPDATE (Peter E)

* Allow elog() to return error codes, module name, file name, line

number, not just messages (Peter E) [elog]

* Allow international error message support and add error codes [elog]

* Remove unused files during database vacuum or postmaster startup

* -Allow international error message support and add error codes[elog](Peter E)

* -Remove unused sort files on postmaster startup (Bruce)

* Remove unreferenced table files and temp tables during database vacuum

or postmaster startup

* Add table name mapping for numeric file names

* Overhaul pg_hba.conf host-based authentication

* Encrpyt passwords in pg_shadow table using MD5 (Vince)

* Add domain capability [domain]

* Add IPv6 capability to INET/CIDR types

* Add conversion function from text to inet

*-Add conversion function from text to inet

* Store binary-compatible type information in the system

* Support construction of array result values in expressions

* Remove Money type, add money formatting for decimal type

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

* SELECT cash_out(2) crashes because of opaque

* -Add SQL standard function bit_length() (Peter E)

* Make oid use unsigned int more reliably, pg_atoi()

*-Make oid use unsigned int more reliably (Tom)

* ARRAYS

* Allow nulls in arrays

* Allow arrays to be ORDER'ed

VIEWS

* Automatically create rules on views so they are updateable, per SQL92

* Automatically create rules on views so they are updateable, per SQL92 [view]

* Add the functionality for WITH CHECK OPTION clause of CREATE VIEW

* Allow NOTIFY in rules involving conditionals

* Evaluate INSERT rules at end of query, rather than beginning