PostgreSQL TODO List

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

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

Last updated:Fri Jul 111:08:12 EDT 2005

Last updated:Fri Jul 113:05:46 EDT 2005

The most recent version of this document can be viewed at

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

This would allow server log information to be easily loaded into

a database for analysis.

* Prevent default re-use of sysids for dropped users andgroups

* Prevent default re-use of sysids for dropped users androles

Currently, if a user is removed while he still owns objects, a new

user given might be given their user id and inherit the

* Add ON COMMIT capability to CREATE TABLE AS SELECT

* Add NOVICE output level for helpful messages like automatic sequence/index

creation

* Add COMMENT ON for all cluster global objects (users,groups, databases

* Add COMMENT ON for all cluster global objects (users,roles, databases

and tablespaces)

* Add an option to automatically use savepoints for each statement in a

multi-statement transaction.

o Add dumping of comments on composite type columns

o Add dumping of comments on index columns

o Replace crude DELETE FROM method of pg_dumpall for cleaning of

users andgroups with separate DROP commands

users androles with separate DROP commands

o -Add dumping and restoring of LOB comments

o Stop dumping CASCADE on DROP TYPE commands in clean mode

o Add full object name to the tag field. eg. for operators we need

<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: Fri Jul 111:08:12 EDT 2005

Last updated: Fri Jul 113:05:46 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>.

<p> This would allow server log information to be easily loaded into

a database for analysis.

</li><li>Prevent default re-use of sysids for dropped users andgroups

</li><li>Prevent default re-use of sysids for dropped users androles

<p> Currently, if a user is removed while he still owns objects, a new

user given might be given their user id and inherit the

previous users objects.

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

</li><li>Add NOVICE output level for helpful messages like automatic sequence/index

creation

</li><li>Add COMMENT ON for all cluster global objects (users,groups, databases

</li><li>Add COMMENT ON for all cluster global objects (users,roles, databases

and tablespaces)

</li><li>Add an option to automatically use savepoints for each statement in a

multi-statement transaction.

</li><li>Add dumping of comments on composite type columns

</li><li>Add dumping of comments on index columns

</li><li>Replace crude DELETE FROM method of pg_dumpall for cleaning of

users andgroups with separate DROP commands

users androles with separate DROP commands

</li><li>-<em>Add dumping and restoring of LOB comments</em>

</li><li>Stop dumping CASCADE on DROP TYPE commands in clean mode

</li><li>Add full object name to the tag field. eg. for operators we need