PostgreSQL TODO List

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

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

Last updated:Sat Jul 3000:05:03 EDT 2005

Last updated:Sat Jul 3023:08:20 EDT 2005

The most recent version of this document can be viewed at

http://www.postgresql.org/docs/faqs.TODO.html.

o Allow postgresql.conf file values to be changed via an SQL API

o Allow the server to be stopped/restarted via an SQL API

* Allow server logs to be remotely read using SQL commands

* Tablespaces

* Add ability to monitor the use of temporary sort files

* -Add session start time and last statement time to pg_stat_activity

* Allow server logs to be remotely read using SQL commands

* -Add a function that returns the start time of the postmaster

throw an error on overflow

* Add 'tid != tid ' operator for use in corruption recovery

* Dates and Times

o Allow infinite dates just like infinite timestamps

enable_constraint_exclusion

* Allow EXPLAIN output to be more easily processed by scripts

* CREATE

o Allow CREATE TABLE AS to determine column lengths for complex

* psql

o Have psql show current values for a sequence

o Move psql backslash database information into the backend, use

mnemonic commands? [psql]

* -Add two-phase commit

* Add the features of packages

o Make private objects accessable only to objects in the same schema

* Allow enable_constraint_exclusion to work for UNIONs like it does for

inheritance

* Allow enable_constraint_exclusion to work for UPDATE and DELETE queries

* GIST

o Add more GIST index support for geometric data types

when the first valid heap lookup happens. This bit would have to

be cleared when a heap tuple is expired.

* Consider automatic caching of queries at various levels:

o Parsed query tree

o Query execute plan

o Query results

the event of a system crash, the bitmap would probably be invalidated.

* Add system view to show free space map contents

* Auto-vacuum

o -Move into the backend code

* Fix sgmltools so PDFs can be generated with bookmarks

* Add C code on Unix to copy directories for use in creating new databases

* Win32

o Remove configure.in check for link failure when cause is found

like towupper(). However, UTF8 already works with normal

locales but provides no ordering or character set classes.

* Wire Protocol Changes

o Allow dynamic character set handling

<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated: Sat Jul 3000:05:03 EDT 2005

Last updated: Sat Jul 3023:08:20 EDT 2005

<p>The most recent version of this document can be viewed at<br/>

<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.

</li><li>Allow postgresql.conf file values to be changed via an SQL API

</li><li>Allow the server to be stopped/restarted via an SQL API

<li>Allow server logs to be remotely read using SQL commands

</li><li>Tablespaces

</li><li>Add ability to monitor the use of temporary sort files

</li><li>-<em>Add session start time and last statement time to pg_stat_activity</em>

</li><li>Allow server logs to be remotely read using SQL commands

</li><li>-<em>Add a function that returns the start time of the postmaster</em>

<h1><aname="section_4">Data Types</a></h1>