public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tatsuo Ishii <[email protected]>
To: [email protected]
Subject: pgpool: Fix query cache to invalidate cache when MERGE statement is use
Date: Tue, 07 Apr 2026 03:59:25 +0000
Message-ID: <[email protected]> (raw)

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 <[email protected]>
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=00d45b895452cbd41f3d8963e8d197231a3fd...

Modified Files
--------------
src/query_cache/pool_memqcache.c | 8 +++++++-
1 file changed, 7 insertions(+), 1 deletion(-)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgpool: Fix query cache to invalidate cache when MERGE statement is use
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox