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

[Hou, Zhijie]

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.

Best regards,



-------------- next part --------------
A non-text attachment was scrubbed...
Name: Update-test_4_1.sh.patch
Type: application/octet-stream
Size: 1723 bytes
Desc: Update-test_4_1.sh.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200805/958e56f3/attachment.obj>