PostgreSQL TODO List

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

Current maintainer:Bruce Momjian (bruce@momjian.us)

Last updated:Thu Apr 2413:32:33 EDT 2008

Last updated:Thu Apr 2414:22:49 EDT 2008

The most recent version of this document can be viewed at

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

http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php

* Improve failure message when DROP DATABASE is used on a database that

has prepared transactions

* Allow prepared transactions with temporary tables created and dropped

in the same transaction, and when an ON COMMIT DELETE ROWS temporary

table is accessed

http://archives.postgresql.org/pgsql-hackers/2008-03/msg00047.php

* Add a GUC variable to warn about non-standard SQL usage in queries

* Add SQL-standard MERGE/REPLACE/UPSERT command

* Add column to pg_stat_activity that shows the progress of long-running

commands like CREATE INDEX and VACUUM

* Implement SQL:2003 window functions

* Improve failure message when DROP DATABASE is used on a database that

has prepared transactions

* Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause

http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php

<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:bruce@momjian.us">bruce@momjian.us</a>)<br/>

Last updated: Thu Apr 2413:32:33 EDT 2008

Last updated: Thu Apr 2414:22:49 EDT 2008

<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>Improve logging of prepared transactions recovered during startup

<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php">http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php</a>

</li><li>Improve failure message when DROP DATABASE is used on a database that

has prepared transactions

</li><li>Allow prepared transactions with temporary tables created and dropped

in the same transaction, and when an ON COMMIT DELETE ROWS temporary

table is accessed

<p><ahref="http://archives.postgresql.org/pgsql-hackers/2008-03/msg00047.php">http://archives.postgresql.org/pgsql-hackers/2008-03/msg00047.php</a>

</li><li>Add a GUC variable to warn about non-standard SQL usage in queries

</li><li>Add SQL-standard MERGE/REPLACE/UPSERT command

</li><li>Add column to pg_stat_activity that shows the progress of long-running

commands like CREATE INDEX and VACUUM

</li><li>Implement SQL:2003 window functions

</li><li>Improve failure message when DROP DATABASE is used on a database that

has prepared transactions

</li><li>Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause

<p><ahref="http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php">http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php</a>

<ahref="http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php">http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php</a>