pgpool: Fix: primary_routing_query_pattern_list retains old values afte

From: Taiki Koshino <koshino(at)sraoss(dot)co(dot)jp>
To: pgpool-committers(at)lists(dot)postgresql(dot)org
Subject: pgpool: Fix: primary_routing_query_pattern_list retains old values afte
Date: 2026-05-21 01:50:24
Message-ID: E1wPsYK-004qRo-09@gothos.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-committers

Fix: primary_routing_query_pattern_list retains old values after reload

This commit fixes an issue where primary_routing_query_pattern_list retained
old regex patterns after configuration reload.

Previously, the old regex array was not cleared during reload, and new values
were simply appended. As a result, patterns from the previous configuration
were not discarded and remained in memory.

This commit ensures that the existing regex pattern array is properly cleared
during reload, so that stale values are removed before new values are applied.

The same issue also affected write_function_list, read_only_function_list,
cache_safe_memqcache_table_list, and cache_unsafe_memqcache_table_list,
and the fix has been applied consistently to these configuration parameters as well.

Discussion: https://github.com/pgpool/pgpool2/issues/151
Backpatch-through: v4.3

Branch
------
V4_7_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=a70e6e82ed476d47e3237722ce78d742b71acfb9

Modified Files
--------------
src/config/pool_config_variables.c | 68 ++++++++++++++++++++++++++++++++++++--
1 file changed, 66 insertions(+), 2 deletions(-)

Browse pgpool-committers by date

  From Date Subject
Next Message Taiki Koshino 2026-05-21 01:51:08 pgpool: Fix: primary_routing_query_pattern_list retains old values afte
Previous Message Taiki Koshino 2026-05-21 01:49:43 pgpool: Fix: primary_routing_query_pattern_list retains old values afte