summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2019-06-01 15:34:02 -0400
committerMichael Paquier <michael@paquier.xyz>2019-06-01 15:34:02 -0400
commit5b8c93c8742a3779e59759f8e482428246e8547c (patch)
tree1cb15bd7c2ecd063ac20ca3d975e4d876c333f38
parent683c17b3071f4ad7c78f106f25118fc07b350be9 (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
-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 1d40d50ae02..b39c283614c 100644
--- a/doc/src/sgml/information_schema.sgml
+++ b/doc/src/sgml/information_schema.sgml
@@ -6661,7 +6661,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>