[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