Hi,

Seems that per the documentation on information_schema.views [1] we do not support check_options ("Applies to a feature not available in PostgreSQL").


Attached is a patch that fix this description. As CHECK OPTION is supported since 9.4, the patch might be applied on all versions since 9.4.


[1] https://www.postgresql.org/docs/current/infoschema-views.html

--
Gilles Darold
http://www.darold.net/

diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml
index 234a3bb6d1..d8c7902ff8 100644
--- a/doc/src/sgml/information_schema.sgml
+++ b/doc/src/sgml/information_schema.sgml
@@ -6737,7 +6737,7 @@ 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</productname></entry>
+      <entry><literal>CASCADED</literal> or <literal>LOCAL</literal> if a check option is defined, <literal>NONE</literal> if not</entry>
      </row>
 
      <row>

Reply via email to