Doc fix on information_schema.views

Started by Gilles Daroldover 6 years ago2 messages
#1Gilles Darold
gilles@darold.net
1 attachment(s)

Hi,

Seems that per the documentation on information_schema.views [1]https://www.postgresql.org/docs/current/infoschema-views.html 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/

Attachments:

patch_doc_check_option_information_schema_views-v1.difftext/x-patch; name=patch_doc_check_option_information_schema_views-v1.diffDownload
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>
#2Michael Paquier
michael@paquier.xyz
In reply to: Gilles Darold (#1)
Re: Doc fix on information_schema.views

On Wed, May 29, 2019 at 02:26:50PM +0200, Gilles Darold wrote:

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.

Thanks Gilles! Applied and back-patched.
--
Michael