[Pgpool-general] Error with streaming/balancing / pgpool 3.0.4

[Toshihiro Kitagawa]

On Mon, 22 Aug 2011 14:07:42 +0200
Olivier NOEL <nolivfr at gmail.com> wrote:

> 2011/8/22 Toshihiro Kitagawa <kitagawa at sraoss.co.jp>:
> 
> >> I have to put in the blacklist all the functions which contain DML/DDL
> >> ? I have 700+ functions...
> >
> > There is white_function_list too, just in case.
> > In addition, pgpool-II 3.1 allows to use regular expressions in
> > black and white function list.
> 
> So if a function is on the white list, it will be sent to all the
> servers and f it's not, it will only be sent to the master ?

Correctly, if a function is on the white list, it will be sent to
one of the servers and if it's not, it will only be sent to the master.

> If this is the case, it will be easier for me to update my list.
> Thanks !! (and btw, it works with the functions on the blacklist).

Only one of these two lists can be filled in a configuration.

-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan