PostgreSQL TODO List

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

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

Last updated:Sat Feb25 11:34:42 EST 2006

Last updated:Sun Feb26 16:22:48 EST 2006

The most recent version of this document can be viewed at

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

* -Prevent INET cast to CIDR from dropping netmask, SELECT '1.1.1.1'::inet::cidr

* -Allow INET + INT8 to increment the host part of the address or

throw an error on overflow

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

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

* Allow user-defined types to specify a type modifier at table creation

time

<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 Feb25 11:34:42 EST 2006

Last updated:Sun Feb26 16:22:48 EST 2006

<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>-<em>Prevent INET cast to CIDR from dropping netmask, SELECT '<ahref="telnet://1.1.1.1">1.1.1.1</a>'::inet::cidr</em>

</li><li>-<em>Allow INET + INT8 to increment the host part of the address or</em>

throw an error on overflow

</li><li>%Add 'tid != tid ' operator for use in corruption recovery

</li><li>-<em>Add 'tid != tid ' operator for use in corruption recovery</em>

</li><li>Allow user-defined types to specify a type modifier at table creation

time

</li><li>Dates and Times

<h1><aname="section_7">Views / Rules</a></h1>

<li>%Automatically create rules on views so they are updateable, per SQL99

<li>Automatically create rules on views so they are updateable, per SQL99

<p> We can only auto-create rules for simple views. For more complex

cases users will still have to write rules.

cases users will still have to write rules manually.

</li><li>Add the functionality for WITH CHECK OPTION clause of CREATE VIEW

</li><li>Allow NOTIFY in rules involving conditionals

called, and the table is locked in exclusive mode.

</li><li>Allow PREPARE of cursors

</li><li>Allow PREPARE to automatically determine parameter types based on the SQL

statement

</li><li>-<em>Allow PREPARE to automatically determine parameter types based on the SQL</em>

statement (Neil)

</li><li>Allow finer control over the caching of prepared query plans

<p> Currently, queries prepared via the libpq API are planned on first

execute using the supplied parameters --- allow SQL PREPARE to do the

expressions like SELECT col1 || col2

</li><li>Use more reliable method for CREATE DATABASE to get a consistent

copy of db?

</li><li>Add ON COMMIT capability to CREATE TABLE AS ... SELECT

</li><li>-<em>Add ON COMMIT capability to CREATE TABLE AS ... SELECT</em>

</li><li>UPDATE

</li><li>%Promote debug_query_string into a server-side function current_query()

</li><li>%Allow the identifier length to be increased via a configure option

</li><li>Allow cross-compiling by generating the zic database on the target system

</li><li>Improve NLSmaintenace of libpgport messages linked onto applications

</li><li>Improve NLSmaintenance of libpgport messages linked onto applications

</li><li>Allow ecpg to work with MSVC and BCC

</li><li>Add xpath_array() to /contrib/xml2 to return results as an array

</li><li>Allow building in directories containing spaces

spaces and then copy the install to a directory with spaces.

</li><li>Fix sgmltools so PDFs can be generated with bookmarks

</li><li>%Clean up compiler warnings (especially with gcc version 4)

</li><li>-*%Clean up compiler warnings (especially with gcc version 4)*

</li><li>Use UTF8 encoding for NLS messages so all server encodings can

read them properly

</li><li>Update Bonjour to work with newer cross-platform SDK