summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorMichael Paquier2019-06-01 19:34:08 +0000
committerMichael Paquier2019-06-01 19:34:08 +0000
commita4291d07fcf20f0ba61031d23d02916723a5e23f (patch)
treefd9f40189f36fc4bad4a6fa86080eebb2d7849e4 /doc/src
parentc332c94adb70a21f2389d1e6f4072ff33186d7c0 (diff)
Fix documentation of check_option in information_schema.views
Support of CHECK OPTION for updatable views has been added in 9.4, but the documentation of information_schema never got the call even if the information displayed is correct. Author: Gilles Darold Discussion: https://postgr.es/m/75d07704-6c74-4f26-656a-10045c01a17e@darold.net Backpatch-through: 9.4
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/information_schema.sgml6
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml
index e5a02801f12..306f49fee34 100644
--- a/doc/src/sgml/information_schema.sgml
+++ b/doc/src/sgml/information_schema.sgml
@@ -6640,7 +6640,11 @@ ORDER BY c.ordinal_position;
<row>
<entry><literal>check_option</literal></entry>
<entry><type>character_data</type></entry>
- <entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
+ <entry>
+ <literal>CASCADED</literal> or <literal>LOCAL</literal> if the view
+ has a <literal>CHECK OPTION</literal> defined on it,
+ <literal>NONE</literal> if not
+ </entry>
</row>
<row>