[pgpool-hackers: 3770] Re: query cache not deleted when use "EXPLAIN ANALYZE"

[Tatsuo Ishii]

> Hi Ishii san,
> 
>> >
>> > When using memory query cache, I found the execution of following sql
>> will not delete the cache.
>> > 	" EXPLAIN ANALYZE INSERT INTO test VALUES(1);"
>> >
>> > Since test will be updated by this sql, I think it's better to delete
>> the cache.
>> 
>> Good catch!
>> 
>> > I try to modify the function pool_extract_table_oids to fix it.
>> > See the attachment for the patch.
>> 
>> Thank you. However the regression test patch does not apply to 4.1-stable
>> or older branches. I think these patches also needed to be applied to those
>> branches. If so, can you please provide the regression test patch for
>> 4.1-stable? Then probably I could port it to
>> 4.0 or older branches.
>> 
> 
> Thanks for your response.
> I have made the patch for 4.1-stable.

Thank you for your prompt response!

I am going to commit/push this along with your previous patches within
two hours.

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