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