[pgpool-general: 6717] Re: Help to handle functions contains DML statements using black_list_functions option
sivapgpool89 at gmail.com
Tue Sep 17 23:25:25 JST 2019
Thanks a lot Tatsuo.
On Tue, Sep 17, 2019, 7:44 PM Tatsuo Ishii <ishii at sraoss.co.jp wrote:
> > Thank you very much Tatsuo.
> > In my case , team is continuing creating function's and every time we
> > to update this list in black_list_function and this seems difficult.
> > Is we have any method to handle all future creating function's?
> If you have certain rule for naming those writing functions and the
> rule can be described in regular expressions, then you can write the
> regular expressions in black_function_list.
> Another idea is, using white_function_list instead of
> black_function_list. This may give a false positive (i.e. a read only
> function which is not in the white_function_list is routed to primary
> PostgreSQL server), but it will not give any error.
> Best regards,
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general