diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-01-06 20:00:10 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-01-06 20:00:10 +0000 |
| commit | bd87cd5ffb5b17b9dddaad5036672bab7c6f669a (patch) | |
| tree | 931c975bf074a326766f48c84cdb8aa5ad436fd4 | |
| parent | 9cfcfd7c22bd4fe4b0c7c3904faba5fb4367261e (diff) | |
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
>
>
>
| -rw-r--r-- | doc/TODO | 27 | ||||
| -rw-r--r-- | doc/src/FAQ/TODO.html | 25 |
2 files changed, 30 insertions, 22 deletions
@@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Sat Jan 6 14:41:18 EST 2007 +Last updated: Sat Jan 6 14:59:54 EST 2007 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -855,16 +855,6 @@ Dependency Checking Indexes ======= -* 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 * Add UNIQUE capability to non-btree indexes * Prevent index uniqueness checks when UPDATE does not modify the column @@ -904,12 +894,27 @@ Indexes This is difficult because it requires datatype-specific knowledge. +* 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 + + * GIST o Add more GIST index support for geometric data types o Allow GIST indexes to create certain complex index types, like digital trees (see Aoki) + * Hash o Pack hash index buckets onto disk pages more efficiently diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index e0788ba61da..a6de1d2cc9c 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@ <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> <h1><a name="section_1">PostgreSQL TODO List</a></h1> <p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/> -Last updated: Sat Jan 6 14:41:18 EST 2007 +Last updated: Sat Jan 6 14:59:54 EST 2007 </p> <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. @@ -776,16 +776,7 @@ first. <h1><a name="section_12">Indexes</a></h1> <ul> - <li>Allow inherited tables to inherit index, UNIQUE constraint, and primary - key, foreign key - </li><li>UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from - inherited table: INSERT INTO inherit_table (unique_index_col) VALUES - (dup) should fail -<p> The main difficulty with this item is the problem of creating an index - that can span more than one table. -</p> - </li><li>Allow SELECT ... FOR UPDATE on inherited tables - </li><li>Add UNIQUE capability to non-btree indexes + <li>Add UNIQUE capability to non-btree indexes </li><li>Prevent index uniqueness checks when UPDATE does not modify the column <p> Uniqueness (index) checks are done when updating a column even if the column is not modified by the UPDATE. @@ -818,6 +809,18 @@ first. several rows as a single index entry <p> This is difficult because it requires datatype-specific knowledge. </p> + </li><li>Inheritance + <ul> + <li>Allow inherited tables to inherit indexes, UNIQUE constraints, + and primary/foreign keys + </li><li>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 +<p> The main difficulty with this item is the problem of + creating an index that can span multiple tables. +</p> + </li><li>Allow SELECT ... FOR UPDATE on inherited tables + </li></ul> </li><li>GIST <ul> <li>Add more GIST index support for geometric data types |