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

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

I try to modify the function pool_extract_table_oids to fix it.
See the attachment for the patch.

Best regards,
houzj


-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0002-Update-test.sh.patch
Type: application/octet-stream
Size: 2100 bytes
Desc: 0002-Update-test.sh.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200804/892cf598/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-Update-pool_memqcache.c.patch
Type: application/octet-stream
Size: 981 bytes
Desc: 0001-Update-pool_memqcache.c.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200804/892cf598/attachment-0001.obj>