pgsql: Move INDEX inheritance out into a separate section: < * Allow
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 failThe 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)