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

Patch attached.

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: query_cache_invalidation.patch
Type: text/x-patch
Size: 2818 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20241017/039fb008/attachment.bin>