[Pgpool-hackers] regexp in white_function_list and black_function_list

[Tatsuo Ishii]

Sounds like a great idea. Could you send me the patches?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi all,
> 
> We have to connect some customers apps to PgPool II that use intensive
> function call. The problem is that writting then all to
> white_function_list or black_function_list is a pain to maintain.
> 
> Instead we'd like to tell to the developers to always prefix all write
> functions with "write_" as we can use a simple regex in those
> configuration directives as follow:
> 
>     black_function_list = 'nextval,setval,write_.*'
>  
> Or in an other way if this is more easy to maintain in the apps add a
> "read_" or "get_" prefix to all function that are doing read only
> queries to PostgreSQL. And so we can write things like that:
> 
>     white_function_list = 'read_.*,get_.*'
> 
> Do you think this is something that can be useful for PgPool II ? If so
> I already have a patch for that, then you just have to let me know how
> to send it to you.
> 
> Thanks for your great work.
> 
> Best regards,
> 
> -- 
> Gilles Darold
> http://dalibo.com
> 
> _______________________________________________
> Pgpool-hackers mailing list
> Pgpool-hackers at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-hackers