[pgpool-hackers: 3771] 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.

Done. Thank you!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp