diff options
| author | Michael Paquier <michael@paquier.xyz> | 2019-06-01 15:34:17 -0400 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2019-06-01 15:34:17 -0400 |
| commit | 0022aa31ecc83bd9d6eb8a6c9ffc8f5849875342 (patch) | |
| tree | d145a43cead8c252240fa934cdb6149785900a66 | |
| parent | da53e4f93fb3a03f6d5a7d4b98135361fae2ade0 (diff) | |
| download | postgresql-0022aa31ecc83bd9d6eb8a6c9ffc8f5849875342.tar.gz postgresql-0022aa31ecc83bd9d6eb8a6c9ffc8f5849875342.zip | |
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.sgml | 6 |
1 files changed, 5 insertions, 1 deletions
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> |