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:51:45
Message-ID: E1wPsZd-004qh6-0C@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_5_STABLE

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

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:53:14 pgpool: Fix: primary_routing_query_pattern_list retains old values afte
Previous Message Taiki Koshino 2026-05-21 01:51:08 pgpool: Fix: primary_routing_query_pattern_list retains old values afte