[Pgpool-general] White and blacklist of function

2011-02-07 Thread Wouter D'Haeseleer
Hi All, Just an enhancement question. I have noticed that you need to keep a list of blacklisted functions in case one of the functions does a write to the db. Maybe it's a good idea to tackle this in an automated way. Since if you do this kind of query on the standby server you will get a good

Re: [Pgpool-general] White and blacklist of function

2011-02-07 Thread Guillaume Lelarge
Le 07/02/2011 09:35, Wouter D'Haeseleer a écrit : > Hi All, > > Just an enhancement question. > I have noticed that you need to keep a list of blacklisted functions in case > one of the functions does a write to the db. > > Maybe it's a good idea to tackle this in an automated way. > Since if yo

Re: [Pgpool-general] White and blacklist of function

2011-02-09 Thread Tatsuo Ishii
Hi Guillaume, It was nice to see you in Paris.. > This won't be easy to do. Let's say you have this query : > > SELECT function_which_writes(), function_which_doesnt_write; > > It fails with an error indicating that one tried to write, which > function is the culprit? pgpool-II can't guess that