File tree Expand file tree Collapse file tree 2 files changed +7
-3
lines changed Expand file tree Collapse file tree 2 files changed +7
-3
lines changed Original file line number Diff line number Diff line change 2
2
PostgreSQL TODO List
3
3
====================
4
4
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
6
6
7
7
The most recent version of this document can be viewed at
8
8
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -521,6 +521,8 @@ SQL Commands
521
521
like CHECK that were inherited from the parent table
522
522
o Add ALTER TABLE tab ADD/DROP INHERITS parent
523
523
524
+ This allows tables to be added/removed from an inheritance
525
+ hierarchy. This is particularly useful for table partitioning.
524
526
pg_attribute.attislocal has to be set to 'false' for ADD, and
525
527
pg_attribute.attinhcount adjusted appropriately
526
528
Original file line number Diff line number Diff line change 8
8
< body bgcolor ="#FFFFFF " text ="#000000 " link ="#FF0000 " vlink ="#A00000 " alink ="#0000FF ">
9
9
< h1 > < a name ="section_1 "> PostgreSQL TODO List</ a > </ h1 >
10
10
< 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
12
12
</ p >
13
13
< p > The most recent version of this document can be viewed at< br />
14
14
< 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>
477
477
</ li > < li > %Prevent child tables from altering or dropping constraints
478
478
like CHECK that were inherited from the parent table
479
479
</ 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
481
483
pg_attribute.attinhcount adjusted appropriately
482
484
</ p >
483
485
</ li > < li > Have ALTER INDEX update the name of a constraint using that index
You can’t perform that action at this time.
0 commit comments