[pgpool-general: 8974] Re: 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]

Στις 17/11/23 02:46, ο/η Tatsuo Ishii έγραψε:
>>>> a) How easy it could be to implement a new feature in pgpool to
>>>> declare functions that will have to be routed in both primary and
>>>> replica (POOL_BOTH in src/context/pool_query_context.c ).
>>> The implementation will not be that hard. Question is, what is the UI
>>> for the feature (how is like new parameter or parameter changes in
>>> pgpool.conf).
>> Would something like : primary_and_standby_routing_query_pattern_list
>> or both_routing_query_pattern_list make sense ?
> Yes, that's an idea. Another idea is, inventing something like
> "both_routing_function_list", but this limits the key for routing to
> only functions. On the other hand, it's easier for users to write an
> entry because he/she just writes function name on it. The
> query_pattern_list requires to write a regular expression.
Thank you! I would be glad to help with either option if only I had the 
time. I really wish we (at Dynacom Tankers) could allocate some time for 
the junior programmers to do some serious C coding.
>
>>>> b) if there was a mechanism in postgresql that a SET foo_guc_var="val"
>>>> would result in calling a function.
>>> I haven't tried myself, but I think you can do that by using
>>> "customized options".
>>> https://www.postgresql.org/docs/current/runtime-config-custom.html. It
>>> allows to define "hook" that are called when the custom option is set
>>> (and on other occasions).
>> Thank you, writing an extension seems more involved, IMHO the straight
>> forward solution you commented above sounds more correct!
> Yeah, creating your own customized option needs more codes.
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS LLC
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp

-- 
Achilleas Mantzios
  IT DEV - HEAD
  IT DEPT
  Dynacom Tankers Mgmt