<div>No problem, </div><div dir="auto"><div dir="auto">Awesome, thanks!</div><div dir="auto"><br></div></div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Op do 18 apr. 2019 om 02:02 schreef Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Sebastiaan,<br>
<br>
Thank you for pointing it out. Apparently that was my mistake. I am<br>
going to fix them.<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" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> Hi Hackers,<br>
> Today I visited a customer of ours using PgPool, and I noticed that they had this in their configuration file:<br>
> <br>
> black_function_list = 'nextval,setval,nextval,setval'<br>
> <br>
> I questioned them that there was no obvious way for this, but they reflected that question, since it is in the pgpool.conf.sample.<br>
> I tracked it down to this commit:<br>
> <br>
> commit f907fe8fdab0aabd7636efe15bca93dd748289d0<br>
> Author: Tatsuo Ishii <<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>><br>
> Date: Sun Aug 17 21:24:19 2014 +0900<br>
> <br>
> First cut of database_redirect_preference_list and app_name_redirect_preference_list implementation.<br>
> <br>
> These allow more fine control of load balancing by specifying database<br>
> name or application name. See [pgpool-hackers: 589] for more details.<br>
> <br>
> And mainly this change:<br>
> <br>
> diff --git a/src/sample/pgpool.conf.sample b/src/sample/pgpool.conf.sample<br>
> index 1088270a..d8666813 100644<br>
> --- a/src/sample/pgpool.conf.sample<br>
> +++ b/src/sample/pgpool.conf.sample<br>
> @@ -292,11 +292,20 @@ white_function_list = ''<br>
> # Comma separated list of function names<br>
> # that don't write to database<br>
> # Regexp are accepted<br>
> -black_function_list = 'nextval,setval'<br>
> +black_function_list = 'nextval,setval,nextval,setval'<br>
> # Comma separated list of function names<br>
> # that write to database<br>
> # Regexp are accepted<br>
> <br>
> Can anyone explain if this change is meant, and if so, elaborate on the exact purpose?<br>
> Or maybe this is something to fix?<br>
> <br>
> Please let me know if you might have any info, and if I can do anything to have this fixed for clarity (if it should)...<br>
> Not the most prudent issue, but easily fixed, right?<br>
> Thanks in advance,<br>
> <br>
</blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span style="color:rgb(0,0,0);font-family:-webkit-standard;font-size:medium"> </span><br style="color:rgb(0,0,0);font-family:-webkit-standard"><span style="color:rgb(0,0,0);font-family:-webkit-standard;font-size:medium"> </span><br style="color:rgb(0,0,0);font-family:-webkit-standard"><table cellpadding="0" cellspacing="0" border="0" style="color:rgb(0,0,0);font-family:-webkit-standard;min-width:320px;border-collapse:collapse;border:none"><tbody><tr valign="top"><td width="116" rowspan="5" style="width:116px;vertical-align:top"><a href="http://www.enterprisedb.com/" style="text-decoration:none" target="_blank"><img src="https://36beta.com/signature/img/email_logo.png" alt="EDB Postgres" border="0" width="103" height="60" style="display:block"></a></td><td width="16" rowspan="5" style="width:16px;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204)"> </td><td style="min-width:188px;font-family:Arial,sans-serif;font-size:14px;line-height:18px;vertical-align:top"><div style="font-size:16px;font-weight:bold;line-height:18px">Sebastiaan Alexander Mannem</div><div style="line-height:18px">Senior Consultant</div></td></tr><tr valign="top"><td style="padding-top:14px;font-family:Arial,sans-serif;font-size:14px;line-height:18px;vertical-align:top"><a href="http://maps.google.com/maps?f=q&source=embed&hl=en&geocode=&q=Anthony+Fokkerweg+1+1059+CM+Amsterdam%2C+The+Netherlands&ie=UTF8&hq=&hnear=Anthony+Fokkerweg+1+1059+CM+Amsterdam%2C+The+Netherlands&iwloc=near" style="text-decoration:none;line-height:18px;color:rgb(0,0,0)" target="_blank">Anthony Fokkerweg 1<br>1059 CM Amsterdam, The Netherlands</a></td></tr><tr valign="top"><td style="padding-top:14px;font-family:Arial,sans-serif;font-size:14px;line-height:18px;vertical-align:top"><div style="line-height:18px">T: <a href="tel:+31682521560" style="text-decoration:none;color:rgb(0,0,0);line-height:18px" target="_blank">+31 6 82521560</a></div></td></tr><tr valign="top"><td style="padding-top:15px;font-family:Arial,sans-serif;font-size:14px;line-height:18px;vertical-align:top"><a href="http://www.edbpostgres.com/" style="text-decoration:none;color:rgb(255,102,51);font-weight:bold;line-height:20px" target="_blank">www.edbpostgres.com</a></td></tr><tr><td style="padding-top:25px;line-height:19px;vertical-align:top"><table width="125" cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse;border:none;width:125px;height:19px;line-height:19px"><tbody><tr style="vertical-align:bottom"><td width="25" style="width:25px"><a href="http://blogs.enterprisedb.com/" style="text-decoration:none" target="_blank"><img src="https://36beta.com/signature/img/social_rss.png" alt="Blog Feed" title="Blog Feed" border="0" width="19" height="19" style="display:block"></a></td><td width="25" style="width:25px"><a href="https://www.facebook.com/EnterpriseDB" style="text-decoration:none" target="_blank"><img src="https://36beta.com/signature/img/social_fb.png" alt="Facebook" title="Facebook" border="0" width="19" height="19" style="display:block"></a></td><td width="25" style="width:25px"><a href="https://twitter.com/EDBPostgres" style="text-decoration:none" target="_blank"><img src="https://36beta.com/signature/img/social_tw.png" alt="Twitter" title="Twitter" border="0" width="19" height="19" style="display:block"></a></td><td width="25" style="width:25px"><a href="https://www.linkedin.com/company/14958?trk=tyah" style="text-decoration:none" target="_blank"><img src="https://36beta.com/signature/img/social_li.png" alt="LinkedIn" title="LinkedIn" border="0" width="19" height="19" style="display:block"></a></td><td width="25" style="width:25px"><a href="https://plus.google.com/108046988421677398468" style="text-decoration:none" target="_blank"><img src="https://36beta.com/signature/img/social_gp.png" alt="Google+" title="Google+" border="0" width="19" height="19" style="display:block"></a></td></tr></tbody></table></td></tr></tbody></table><br></div></div>