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>