PostgreSQL TODO List

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

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

Last updated:Fri Jun 30 11:04:17 EDT 2006

Last updated:Sat Jul 1 21:59:41 EDT 2006

The most recent version of this document can be viewed at

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

is used

o %Prevent child tables from altering or dropping constraints

like CHECK that were inherited from the parent table

o Add ALTER TABLE tab ADD/DROP INHERITS parent

This allows tables to be added/removed from an inheritance

hierarchy. This is particularly useful for table partitioning.

http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php

o -Add ALTER TABLE tab INHERIT / NO INHERIT parent

o Have ALTER INDEX update the name of a constraint using that index

o Add ALTER TABLE RENAME CONSTRAINT, update index name also

<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:Fri Jun 30 11:04:17 EDT 2006

Last updated:Sat Jul 1 21:59:41 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>.

is used

</li><li>%Prevent child tables from altering or dropping constraints

like CHECK that were inherited from the parent table

</li><li>Add ALTER TABLE tab ADD/DROP INHERITS parent

<p> This allows tables to be added/removed from an inheritance

hierarchy. This is particularly useful for table partitioning.

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

</li><li>-<em>Add ALTER TABLE tab INHERIT / NO INHERIT parent</em>

</li><li>Have ALTER INDEX update the name of a constraint using that index

</li><li>Add ALTER TABLE RENAME CONSTRAINT, update index name also