[pgpool-hackers: 3721] Re: problem when getting function name

[Tatsuo Ishii]

>> 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.

You are absolutely right. Sorry for my confusion.

> Currently, the result of "SELECT f1()" and "SELECT public.f1()" are both (separately) cached.
> Maybe I misunderstood, Can you give me a hint?

No misunderstanding with your side. My fault.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp