PostgreSQL TODO List

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

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

Last updated:Sun Jul 31 20:52:25 EDT 2005

Last updated:Mon Aug 1 10:04:49 EDT 2005

The most recent version of this document can be viewed at

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

o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME

o Allow ALTER TABLE to change constraint deferrability and actions

o Disallow dropping of an inherited constraint

o Allow objects to be moved to different schemas

o-Allow objects to be moved to different schemas

o Allow ALTER TABLESPACE to move to different directories

o Allow databases to be moved to different tablespaces

o Allow moving system tables to other tablespaces, where possible

* GRANT/REVOKE

o Allow column-level privileges

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

command

o Allow GRANT/REVOKE permissions to be applied to all schema objects

with onecommand

The proposed syntax is:

GRANT SELECT ON ALL TABLES IN public TO phpuser;

<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:Sun Jul 31 20:52:25 EDT 2005

Last updated:Mon Aug 1 10:04:49 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 ALTER TABLE ... ALTER CONSTRAINT ... RENAME

</li><li>Allow ALTER TABLE to change constraint deferrability and actions

</li><li>Disallow dropping of an inherited constraint

</li><li>Allow objects to be moved to different schemas

</li><li>-<em>Allow objects to be moved to different schemas</em>

</li><li>Allow ALTER TABLESPACE to move to different directories

</li><li>Allow databases to be moved to different tablespaces

</li><li>Allow moving system tables to other tablespaces, where possible

</li><li>GRANT/REVOKE

<li>Allow column-level privileges

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

command

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

with one command

<p> The proposed syntax is:

</p><p> GRANT SELECT ON ALL TABLES IN public TO phpuser;

GRANT SELECT ON NEW TABLES IN public TO phpuser;

</li><li>Allow GRANT/REVOKE permissions to be inherited by objects based on

<li>Allow GRANT/REVOKE permissions to be inherited by objects based on

schema permissions