Skip to content

Commit 672f0be

Browse files
committed
Update text:
> This allows tables to be added/removed from an inheritance > hierarchy. This is particularly useful for table partitioning.
1 parent b7741bf commit 672f0be

File tree

2 files changed

+7
-3
lines changed

2 files changed

+7
-3
lines changed

doc/TODO

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated: Tue May 23 16:57:44 EDT 2006
5+
Last updated: Tue May 23 16:59:15 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -521,6 +521,8 @@ SQL Commands
521521
like CHECK that were inherited from the parent table
522522
o Add ALTER TABLE tab ADD/DROP INHERITS parent
523523

524+
This allows tables to be added/removed from an inheritance
525+
hierarchy. This is particularly useful for table partitioning.
524526
pg_attribute.attislocal has to be set to 'false' for ADD, and
525527
pg_attribute.attinhcount adjusted appropriately
526528

doc/src/FAQ/TODO.html

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Tue May 23 16:57:44 EDT 2006
11+
Last updated: Tue May 23 16:59:15 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -477,7 +477,9 @@ <h1><a name="section_8">SQL Commands</a></h1>
477477
</li><li>%Prevent child tables from altering or dropping constraints
478478
like CHECK that were inherited from the parent table
479479
</li><li>Add ALTER TABLE tab ADD/DROP INHERITS parent
480-
<p> pg_attribute.attislocal has to be set to 'false' for ADD, and
480+
<p> This allows tables to be added/removed from an inheritance
481+
hierarchy. This is particularly useful for table partitioning.
482+
pg_attribute.attislocal has to be set to 'false' for ADD, and
481483
pg_attribute.attinhcount adjusted appropriately
482484
</p>
483485
</li><li>Have ALTER INDEX update the name of a constraint using that index

0 commit comments

Comments
 (0)