PostgreSQL TODO List

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

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

Last updated:Fri Jun 9 14:12:22 EDT 2006

Last updated:Fri Jun 9 14:41:37 EDT 2006

The most recent version of this document can be viewed at

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

* Tablespaces

* Allow a database in tablespace t1 with tables created in

o Allow a database in tablespace t1 with tables created in

tablespace t2 to be used as a template for a new database created

with default tablespace t2

To fix this would require modifying pg_class in the newly copied

database, which we don't currently do.

* Allow reporting of which objects are in which tablespaces

o Allow reporting of which objects are in which tablespaces

This item is difficult because a tablespace can contain objects

from multiple databases. There is a server-side function that

GRANT SELECT ON ALL TABLES IN public TO phpuser;

GRANT SELECT ON NEW TABLES IN public TO phpuser;

* Allow GRANT/REVOKE permissions to be inherited by objects based on

o Allow GRANT/REVOKE permissions to be inherited by objects based on

schema permissions

* Allow SERIAL sequences to inherit permissions from the base table?

o Allow SERIAL sequences to inherit permissions from the base table?

* CURSOR

<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 Jun 9 14:12:22 EDT 2006

Last updated: Fri Jun 9 14:41:37 EDT 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>.

requires a tool that will call that function and connect to each

database to find the objects in each database for that tablespace.

<li>%Add a GUC variable to control the tablespace for temporary objects

</li><li>%Add a GUC variable to control the tablespace for temporary objects

and sort files

<p> It could start with a random tablespace from a supplied list and

cycle through the list.

</li><li>Allow WAL replay of CREATE TABLESPACE to work when the directory

</li><li>Allow WAL replay of CREATE TABLESPACE to work when the directory

structure on the recovery computer is different from the original

</li><li>Allow per-tablespace quotas

</li><li>Allow per-tablespace quotas

</li><li>Point-In-Time Recovery (PITR)

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

GRANT SELECT ON NEW TABLES IN public TO phpuser;

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

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

schema permissions

</li><li>Allow SERIAL sequences to inherit permissions from the base table?

</li><li>Allow SERIAL sequences to inherit permissions from the base table?

</li><li>CURSOR