[pgpool-general: 6717] Re: Help to handle functions contains DML statements using black_list_functions option

Siva U sivapgpool89 at gmail.com
Tue Sep 17 23:25:25 JST 2019


Thanks a lot Tatsuo.

Regards,
Siva.

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
> have
> > 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
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190917/be63d35e/attachment.html>


More information about the pgpool-general mailing list