[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