pg.ddx.io pgpool-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgpool: Fix query cache to invalidate cache when MERGE statement is use 5+ messages / 1 participants [nested] [flat]
* pgpool: Fix query cache to invalidate cache when MERGE statement is use @ 2026-04-07 03:59 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Tatsuo Ishii @ 2026-04-07 03:59 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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@tailorbrands.com> Discussion: https://www.postgresql.org/message-id/20260407.090802.1335576118037412011.ishii%40postgresql.org Backpatch-through: v4.4 where MERGE was introduced Branch ------ V4_4_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=fbcbfe5b092fe555dc161c3341a018b822b7b... Modified Files -------------- src/query_cache/pool_memqcache.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgpool: Fix query cache to invalidate cache when MERGE statement is use @ 2026-04-07 03:59 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Tatsuo Ishii @ 2026-04-07 03:59 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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@tailorbrands.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=00d45b895452cbd41f3d8963e8d197231a3fd... Modified Files -------------- src/query_cache/pool_memqcache.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgpool: Fix query cache to invalidate cache when MERGE statement is use @ 2026-04-07 03:59 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Tatsuo Ishii @ 2026-04-07 03:59 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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@tailorbrands.com> Discussion: https://www.postgresql.org/message-id/20260407.090802.1335576118037412011.ishii%40postgresql.org Backpatch-through: v4.4 where MERGE was introduced Branch ------ V4_6_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=5eb8fcbc3c518444a19dee4073237909dd6de... Modified Files -------------- src/query_cache/pool_memqcache.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgpool: Fix query cache to invalidate cache when MERGE statement is use @ 2026-04-07 03:59 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Tatsuo Ishii @ 2026-04-07 03:59 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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@tailorbrands.com> Discussion: https://www.postgresql.org/message-id/20260407.090802.1335576118037412011.ishii%40postgresql.org Backpatch-through: v4.4 where MERGE was introduced Branch ------ V4_7_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=22d332216da336cffa66e825faf604252d764... Modified Files -------------- src/query_cache/pool_memqcache.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgpool: Fix query cache to invalidate cache when MERGE statement is use @ 2026-04-07 03:59 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Tatsuo Ishii @ 2026-04-07 03:59 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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@tailorbrands.com> Discussion: https://www.postgresql.org/message-id/20260407.090802.1335576118037412011.ishii%40postgresql.org Backpatch-through: v4.4 where MERGE was introduced Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=24755985692be577bdcf487ebddb2c2ff6116... Modified Files -------------- src/query_cache/pool_memqcache.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2026-04-07 03:59 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-04-07 03:59 pgpool: Fix query cache to invalidate cache when MERGE statement is use Tatsuo Ishii <ishii@postgresql.org> 2026-04-07 03:59 pgpool: Fix query cache to invalidate cache when MERGE statement is use Tatsuo Ishii <ishii@postgresql.org> 2026-04-07 03:59 pgpool: Fix query cache to invalidate cache when MERGE statement is use Tatsuo Ishii <ishii@postgresql.org> 2026-04-07 03:59 pgpool: Fix query cache to invalidate cache when MERGE statement is use Tatsuo Ishii <ishii@postgresql.org> 2026-04-07 03:59 pgpool: Fix query cache to invalidate cache when MERGE statement is use Tatsuo Ishii <ishii@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox