Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbd87cd5

Browse files
committed
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>>>
1 parent9cfcfd7 commitbd87cd5

File tree

2 files changed

+30
-22
lines changed

2 files changed

+30
-22
lines changed

‎doc/TODO

Lines changed: 16 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (bruce@momjian.us)
5-
Last updated:Sat Jan 6 14:41:18 EST 2007
5+
Last updated:Sat Jan 6 14:59:54 EST 2007
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -855,16 +855,6 @@ Dependency Checking
855855
Indexes
856856
=======
857857

858-
* Allow inherited tables to inherit index, UNIQUE constraint, and primary
859-
key, foreign key
860-
* UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
861-
inherited table: INSERT INTO inherit_table (unique_index_col) VALUES
862-
(dup) should fail
863-
864-
The main difficulty with this item is the problem of creating an index
865-
that can span more than one table.
866-
867-
* Allow SELECT ... FOR UPDATE on inherited tables
868858
* Add UNIQUE capability to non-btree indexes
869859
* Prevent index uniqueness checks when UPDATE does not modify the column
870860

@@ -904,12 +894,27 @@ Indexes
904894
This is difficult because it requires datatype-specific knowledge.
905895

906896

897+
* Inheritance
898+
899+
o Allow inherited tables to inherit indexes, UNIQUE constraints,
900+
and primary/foreign keys
901+
o Honor UNIQUE INDEX on base column in INSERTs/UPDATEs
902+
on inherited table, e.g. INSERT INTO inherit_table
903+
(unique_index_col) VALUES (dup) should fail
904+
905+
The main difficulty with this item is the problem of
906+
creating an index that can span multiple tables.
907+
908+
o Allow SELECT ... FOR UPDATE on inherited tables
909+
910+
907911
* GIST
908912

909913
o Add more GIST index support for geometric data types
910914
o Allow GIST indexes to create certain complex index types, like
911915
digital trees (see Aoki)
912916

917+
913918
* Hash
914919

915920
o Pack hash index buckets onto disk pages more efficiently

‎doc/src/FAQ/TODO.html

Lines changed: 14 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Sat Jan 6 14:41:18 EST 2007
11+
Last updated: Sat Jan 6 14:59:54 EST 2007
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -776,16 +776,7 @@ <h1><a name="section_11">Dependency Checking</a></h1>
776776
<h1><aname="section_12">Indexes</a></h1>
777777

778778
<ul>
779-
<li>Allow inherited tables to inherit index, UNIQUE constraint, and primary
780-
key, foreign key
781-
</li><li>UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
782-
inherited table: INSERT INTO inherit_table (unique_index_col) VALUES
783-
(dup) should fail
784-
<p> The main difficulty with this item is the problem of creating an index
785-
that can span more than one table.
786-
</p>
787-
</li><li>Allow SELECT ... FOR UPDATE on inherited tables
788-
</li><li>Add UNIQUE capability to non-btree indexes
779+
<li>Add UNIQUE capability to non-btree indexes
789780
</li><li>Prevent index uniqueness checks when UPDATE does not modify the column
790781
<p> Uniqueness (index) checks are done when updating a column even if the
791782
column is not modified by the UPDATE.
@@ -818,6 +809,18 @@ <h1><a name="section_12">Indexes</a></h1>
818809
several rows as a single index entry
819810
<p> This is difficult because it requires datatype-specific knowledge.
820811
</p>
812+
</li><li>Inheritance
813+
<ul>
814+
<li>Allow inherited tables to inherit indexes, UNIQUE constraints,
815+
and primary/foreign keys
816+
</li><li>Honor UNIQUE INDEX on base column in INSERTs/UPDATEs
817+
on inherited table, e.g. INSERT INTO inherit_table
818+
(unique_index_col) VALUES (dup) should fail
819+
<p> The main difficulty with this item is the problem of
820+
creating an index that can span multiple tables.
821+
</p>
822+
</li><li>Allow SELECT ... FOR UPDATE on inherited tables
823+
</li></ul>
821824
</li><li>GIST
822825
<ul>
823826
<li>Add more GIST index support for geometric data types

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp