From a4291d07fcf20f0ba61031d23d02916723a5e23f Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Sat, 1 Jun 2019 15:34:08 -0400 Subject: [PATCH] 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 e5a02801f1..306f49fee3 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -6640,7 +6640,11 @@ ORDER BY c.ordinal_position; check_option character_data - Applies to a feature not available in PostgreSQL + + CASCADED or LOCAL if the view + has a CHECK OPTION defined on it, + NONE if not + -- 2.50.0