[pgpool-hackers: 4533] Re: ALTER ROLE WITH PASSWORD does not need to clear query cache

[Tatsuo Ishii]

> Commit 6b7d585eb1c693e4ffb5b8e6ed9aa0f067fa1b89 invalidates query
> cache if any ALTER ROLE statement is used. Actually this is an
> overkill. Because following queries do not affect the privilege of the
> role.
> 
> - ALTER USER user WITH [ENCRYPTED] PASSWORD
> - ALTER USER user WITH CONNECTION LIMIT
> 
> Attached patch changes the behavior of the query cache invalidation so
> that pgpool does not invalidate the query cache if those queries above
> are used.

I have created test cases for this. V2 patch attached.  This time I
have compressed the patch file to prevent my email client to change
the encoding of the patch.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: v2_query_cache_invalidation_alter_role.patch.gz
Type: application/octet-stream
Size: 1728 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20241020/9d58c2f9/attachment.obj>