pgsql: Move INDEX inheritance out into a separate section: < * Allow - Mailing list pgsql-committers

From momjian@postgresql.org (Bruce Momjian)
Subject pgsql: Move INDEX inheritance out into a separate section: < * Allow
Date
Msg-id 20070106200010.D0E139FA433@postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Move INDEX inheritance out into a separate section:

< * Allow inherited tables to inherit index, UNIQUE constraint, and primary
<   key, foreign key
< * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
<   inherited table:  INSERT INTO inherit_table (unique_index_col) VALUES
<   (dup) should fail
<
<   The main difficulty with this item is the problem of creating an index
<   that can span more than one table.
<
< * Allow SELECT ... FOR UPDATE on inherited tables
> * Inheritance
>
>     o Allow inherited tables to inherit indexes, UNIQUE constraints,
>       and primary/foreign keys
>     o Honor UNIQUE INDEX on base column in INSERTs/UPDATEs
>       on inherited table, e.g.  INSERT INTO inherit_table
>       (unique_index_col) VALUES (dup) should fail
>
>       The main difficulty with this item is the problem of
>       creating an index that can span multiple tables.
>
>     o Allow SELECT ... FOR UPDATE on inherited tables
>
>
>

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.2024 -> r1.2025)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.2024&r2=1.2025)
    pgsql/doc/src/FAQ:
        TODO.html (r1.526 -> r1.527)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.526&r2=1.527)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Done: > * -Allow the pg_xlog directory location to be specified
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Already done in 8.2: < * Allow CREATE INDEX to take an