From efa01b0d684d3ef5ed72e08a23bfcd26a5c6caf3 Mon Sep 17 00:00:00 2001
From: "houzj.fnst" <63178771+sherlockcpp@users.noreply.github.com>
Date: Mon, 20 Jul 2020 14:11:51 +0800
Subject: [PATCH 5/5] Update loadbalance.sgml
---
doc/src/sgml/loadbalance.sgml | 42 ++++++++++++++++++++++++++----------------
1 file changed, 26 insertions(+), 16 deletions(-)
diff --git a/doc/src/sgml/loadbalance.sgml b/doc/src/sgml/loadbalance.sgml
index e17b8b9..0fc3931 100644
--- a/doc/src/sgml/loadbalance.sgml
+++ b/doc/src/sgml/loadbalance.sgml
@@ -513,14 +513,19 @@
- Schema qualifications can not be used
- in
- because Pgpool-II silently
- ignores a schema qualification in function names appearing
- in an input SQL while comparing the list and the input
- SQL. As a result, a schema qualified function name in the
- list never matches function names appearing in the input
- SQL.
+ If the queries can refer the function with and without the schema
+ qualification then you must add both entries(with and without
+ schema name) in the list.
+
+ #For example:
+ #If the queries sometime use "f1()" and other times "public.f1()"
+ #to refer the function f1 then the white_function_list
+ #would be configured as follows.
+
+ white_function_list = "f1,public.f1"
+
+
+
@@ -564,14 +569,19 @@
- Schema qualifications can not be used
- in
- because Pgpool-II silently
- ignores a schema qualification in function names appearing
- in an input SQL while comparing the list and the input
- SQL. As a result, a schema qualified function name in the
- list never matches function names appearing in the input
- SQL.
+ If the queries can refer the function with and without the schema
+ qualification then you must add both entries(with and without
+ schema name) in the list.
+
+ #For example:
+ #If the queries sometime use "f1()" and other times "public.f1()"
+ #to refer the function f1 then the black_function_list
+ #would be configured as follows.
+
+ black_function_list = "f1,public.f1"
+
+
+
--
1.8.3.1