| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | pgpool-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgpool: Fix query cache to invalidate cache when MERGE statement is use |
| Date: | 2026-04-07 03:59:25 |
| Message-ID: | E1w9xb2-001vwR-0S@gothos.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-committers |
Fix query cache to invalidate cache when MERGE statement is used.
MERGE was introduced in PostgreSQL 15 and Pgpool-II 4.4 imported 15's
parer. However, there was an oversight in query cache sub module:
i.e. MERGE statement did not trigger invalidation of query cache.
Author: Nadav Shatz <nadav(at)tailorbrands(dot)com>
Discussion: https://www.postgresql.org/message-id/20260407.090802.1335576118037412011.ishii%40postgresql.org
Backpatch-through: v4.4 where MERGE was introduced
Branch
------
V4_5_STABLE
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=00d45b895452cbd41f3d8963e8d197231a3fd48e
Modified Files
--------------
src/query_cache/pool_memqcache.c | 8 +++++++-
1 file changed, 7 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-04-07 03:59:31 | pgpool: Fix query cache to invalidate cache when MERGE statement is use |
| Previous Message | Tatsuo Ishii | 2026-04-07 03:59:20 | pgpool: Fix query cache to invalidate cache when MERGE statement is use |