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

[Tatsuo Ishii]

Hi Hou, Zhijie,

> Hi pgpool hackers,
> 
> 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.

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