[pgpool-hackers: 3720] Re: problem when getting function name
Hou, Zhijie
houzj.fnst at cn.fujitsu.com
Tue Jul 21 14:14:19 JST 2020
Hi Ishii san,
Thanks for your response.
> This patch itself looks correct. However I have a question. Suppose we have and f1() and public.f1() in the white list. > If "SELECT f1()"and "SELECT public.f1()" are sent from client, the result of "SELECT f1()" and "SELECT public.f1()" are > > both (separately) cached.
> Am I correct? Before we silently strip public.f1() to f1(), and "SELECT public.f1()" will never be cached.
Sorry, I'm not sure I understand what you mean.
white_function_list is part of Load Balancing Settings, It seems does not affect memory cache.
Currently, the result of "SELECT f1()" and "SELECT public.f1()" are both (separately) cached.
Maybe I misunderstood, Can you give me a hint?
Best regards,
houzj
More information about the pgpool-hackers
mailing list