TODO

PostgreSQL TODO List
====================
Current maintainer:	Bruce Momjian (pgman@candle.pha.pa.us)
Last updated:		Fri Sep 16 07:23:51 EDT 2005

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html.

#A hyphen, "-", marks changes that will appear in the upcoming 8.1 release.#
#A percent sign, "%", marks items that are easier to implement.#

Bracketed items, "[]", have more detail.

This list contains all known PostgreSQL bugs and feature requests. If
you would like to work on an item, please read the Developer's FAQ
first.


Administration
==============

* %Remove behavior of postmaster -o after making postmaster/postgres
  flags unique
* %Allow pooled connections to list all prepared queries

  This would allow an application inheriting a pooled connection to know
  the queries prepared in the current session.

* Allow major upgrades without dump/reload, perhaps using pg_upgrade 
  [pg_upgrade]
* Check for unreferenced table files created by transactions that were
  in-progress when the server terminated abruptly
* Allow administrators to safely terminate individual sessions either
  via an SQL function or SIGTERM 

  Lock table corruption following SIGTERM of an individual backend
  has been reported in 8.0.  A possible cause was fixed in 8.1, but
  it is unknown whether other problems exist.  This item mostly
  requires additional testing rather than of writing any new code.

* %Set proper permissions on non-system schemas during db creation

  Currently all schemas are owned by the super-user because they are
  copied from the template1 database.

* Support table partitioning that allows a single table to be stored
  in subtables that are partitioned based on the primary key or a WHERE
  clause


* Improve replication solutions

	o Load balancing

	  You can use any of the master/slave replication servers to use a
	  standby server for data warehousing. To allow read/write queries to
	  multiple servers, you need multi-master replication like pgcluster.

	o Allow replication over unreliable or non-persistent links


* Configuration files

	o %Add "include file" functionality in postgresql.conf
	o %Allow commenting of variables in postgresql.conf to restore them
	  to defaults

	  Currently, if a variable is commented out, it keeps the
	  previous uncommented value until a server restarted.