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

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Move INDEX inheritance out into a separate section: < * Allow
Date: 2007-01-06 20:00:10
Message-ID: 20070106200010.D0E139FA433@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2007-01-06 20:00:53 pgsql: Already done in 8.2: < * Allow CREATE INDEX to take an
Previous Message Bruce Momjian 2007-01-06 19:41:23 pgsql: Done: > * -Allow the pg_xlog directory location to be specified