TODO list for PostgreSQL

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

Last updated:Fri Jul 20 12:07:25 EDT 2001

Last updated:Fri Jul 20 12:14:48 EDT 2001

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

* Allow autocommit so always in a transaction block

* Overhaul bufmgr/lockmgr/transaction manager

* Allow nested transactions (Vadim)

* Allow nested transactions/ savepoints(Vadim)

* Handle transaction rollover (Tom) [transactions]

EXOTIC FEATURES

* Allow SQL92 schemas [schema]

* Allow queries across multiple databases

* Add pre-parsing phase that converts non-ANSI features to supported features

* Allow plug-in modules to emulate features from other databases

* SQL*Net listener that makes PostgreSQL appear as an Oracle database

to clients

* Allow Java server-side programming [java]

connection pooling

* Make blind writes go through the file descriptor cache

* Allow logging of query durations

* Add hash-based aggregates

* Add hash for evaluating GROUP BY aggregates

* Read pg_hba.conf only on postmaster startup or SIGHUP (Bruce)

* Create spinlock sleepers queue so everyone doesn't wake up at once

* Make elog(LOG) in WAL its own output type, distinct from DEBUG

* Rename some /contrib modules from pg* to pg_*

* Move some things from /contrib into main tree, like soundex

* Allow plug-in modules to emulate features from other databases

* Remove warnings created by -Wcast-align

* Move platform-specific ps status display info from ps_status.c to ports

* Allow ps status display to work on Solaris/SVr4-based systems