Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group