• Bruce Momjian's avatar
    Move INDEX inheritance out into a separate section: · bd87cd5f
    Bruce Momjian authored
    < * 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
    >
    >
    >
    bd87cd5f
TODO 53.7 KB