<div dir="auto">Thanks a lot Tatsuo. <div dir="auto"><br></div><div dir="auto">Regards, </div><div dir="auto">Siva.</div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Sep 17, 2019, 7:44 PM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> Thank you very much Tatsuo.<br>
> <br>
> In my case , team is continuing creating function's and every time we have<br>
> to update this list in black_list_function and this seems difficult.<br>
> <br>
> Is we have any method to handle all future creating function's?<br>
<br>
If you have certain rule for naming those writing functions and the<br>
rule can be described in regular expressions, then you can write the<br>
regular expressions in black_function_list.<br>
<br>
Another idea is, using white_function_list instead of<br>
black_function_list. This may give a false positive (i.e. a read only<br>
function which is not in the white_function_list is routed to primary<br>
PostgreSQL server), but it will not give any error.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div>