[pgpool-committers: 8719] pgpool: Fix to not cache SELECT having	functions with return types are
    Tatsuo Ishii 
    ishii at sraoss.co.jp
       
    Wed Jul  6 23:32:07 JST 2022
    
    
  
Fix to not cache SELECT having functions with return types are timestamptz or timetz.
Functions with return type is timestamptz or timetz is affected by time zone setting.
Consider following scenario:
1) SELECT having such functions gets called and cache created.
2) time zone is changed.
3) same SELECT is called and the cache is used. The cache value is
correct any more because of the time zone change.
Discussion: https://www.pgpool.net/pipermail/pgpool-general/2022-July/008367.html
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=47fd46cbcf31b46d93a8ade62fda43b82c39b4e6
Modified Files
--------------
src/test/regression/tests/006.memqcache/test.sh |   3 +
src/utils/pool_select_walker.c                  | 113 ++++++++++++++++++++++--
2 files changed, 108 insertions(+), 8 deletions(-)
    
    
More information about the pgpool-committers
mailing list