aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-01-25 17:51:59 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2011-01-25 17:51:59 -0500
commitbd1ad1b019cda851a3e925133c056930368e6424 (patch)
tree7a0457da38302b33a9ffb79f2904174b22b1805c /doc/src
parent88452d5ba6b3e8ad49133ac1a660ce0725710f8c (diff)
downloadpostgresql-bd1ad1b019cda851a3e925133c056930368e6424.tar.gz
postgresql-bd1ad1b019cda851a3e925133c056930368e6424.zip
Replace pg_class.relhasexclusion with pg_index.indisexclusion.
There isn't any need to track this state on a table-wide basis, and trying to do so introduces undesirable semantic fuzziness. Move the flag to pg_index, where it clearly describes just a single index and can be immutable after index creation.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/catalogs.sgml26
1 files changed, 11 insertions, 15 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 0703df6434e..cdc85e5cc07 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -1707,17 +1707,6 @@
</row>
<row>
- <entry><structfield>relhasexclusion</structfield></entry>
- <entry><type>bool</type></entry>
- <entry></entry>
- <entry>
- For a table, true if the table has (or once had) any exclusion
- constraints; for an index, true if the index supports an exclusion
- constraint
- </entry>
- </row>
-
- <row>
<entry><structfield>relhasrules</structfield></entry>
<entry><type>bool</type></entry>
<entry></entry>
@@ -2046,8 +2035,7 @@
<para>
<literal>pg_class.relchecks</literal> needs to agree with the
number of check-constraint entries found in this table for each
- relation. Also, <literal>pg_class.relhasexclusion</literal> must
- be true if there are any exclusion-constraint entries for the relation.
+ relation.
</para>
</note>
@@ -3057,11 +3045,19 @@
</row>
<row>
+ <entry><structfield>indisexclusion</structfield></entry>
+ <entry><type>bool</type></entry>
+ <entry></entry>
+ <entry>If true, this index supports an exclusion constraint</entry>
+ </row>
+
+ <row>
<entry><structfield>indimmediate</structfield></entry>
<entry><type>bool</type></entry>
<entry></entry>
- <entry>If true, the uniqueness check is enforced immediately on insertion
- (<structfield>indisunique</> should always be true when this is true)</entry>
+ <entry>If true, the uniqueness check is enforced immediately on
+ insertion
+ (irrelevant if <structfield>indisunique</> is not true)</entry>
</row>
<row>