PostgreSQL TODO List

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

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

Last updated:Tue Jun 1411:11:04 EDT 2005

Last updated:Tue Jun 1414:10:17 EDT 2005

The most recent version of this document can be viewed at

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

* Allow major upgrades without dump/reload, perhaps using pg_upgrade

[pg_upgrade]

* Have SHOW ALL and pg_settings show descriptions for server-side variables

* Allow GRANT/REVOKE permissions to be applied to all schema objects with one

command

* SHOW/SET

o Have SHOW ALL and pg_settings show descriptions for server-side variables

o Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM

ANALYZE, and CLUSTER

o Add SET PATH for schemas (?)

<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: Tue Jun 1411:11:04 EDT 2005

Last updated: Tue Jun 1414:10:17 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 major upgrades without dump/reload, perhaps using pg_upgrade

[<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?pg_upgrade">pg_upgrade</a>]

</li><li>Have SHOW ALL and pg_settings show descriptions for server-side variables

</li><li>Allow GRANT/REVOKE permissions to be applied to all schema objects with one

command

<p> The proposed syntax is:

</li><li>SHOW/SET

<li>Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM

<li>Have SHOW ALL and pg_settings show descriptions for server-side variables

</li><li>Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM

ANALYZE, and CLUSTER

</li><li>Add SET PATH for schemas (?)

<p> This is basically the same as SET search_path.