PostgreSQL TODO List

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

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

Last updated:Mon May22 16:39:01 EDT 2006

Last updated:Tue May23 16:57:44 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

pg_attribute.attislocal has to be set to 'false' for ADD, and

pg_attribute.attinhcount adjusted appropriately

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:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated:Mon May22 16:39:01 EDT 2006

Last updated:Tue May23 16:57:44 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> pg_attribute.attislocal has to be set to 'false' for ADD, and

pg_attribute.attinhcount adjusted appropriately

</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