[pgpool-general: 8963] Can we define a function func_set_search_path so that select func_set_search_path will execute to both primary and secondary nodes ?
    Achilleas Mantzios 
    a.mantzios at cloud.gatewaynet.com
       
    Mon Nov 13 05:19:11 JST 2023
    
    
  
Hello pgpool world
pgpool thankfully sends all SET commands to both primary and secondary 
nodes. Hence, it handles correctly SET search_path TO ...;  But what if 
we have a more complex function or procedure to handle the setting 
search_path? How can we tell pgpool to execute this function/procedure 
to all load balancing nodes ?
Thank you!
-- 
Achilleas Mantzios
  IT DEV - HEAD
  IT DEPT
  Dynacom Tankers Mgmt
    
    
More information about the pgpool-general
mailing list