[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