Thread: pgsql: Move INDEX inheritance out into a separate section: < * Allow

pgsql: Move INDEX inheritance out into a separate section: < * Allow

From

momjian@postgresql.org (Bruce Momjian)

Date:

06 January 2007, 19:00:15

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)