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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Sep 17 23:14:07 JST 2019

> 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

More information about the pgpool-general mailing list