postgres.git / summary / log / commit / refs

commit    0022aa31ecc83bd9d6eb8a6c9ffc8f5849875342
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Sat Jun 01 19:34:17 2019 +0000

    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


 doc/src/sgml/information_schema.sgml | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

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>


[parent: da53e4f93fb3]