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

Started by Bruce Momjianover 19 years ago1 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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&amp;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&amp;r2=1.527)