[Pgpool-general] White and blacklist of function

[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 error from postgres saying it is not possible to do update querys on the standby.
If this error is tackled in pgpool and send to the primary then pgool could maintain a list of querys which will fail on the standby.

Therefore an autolearning feature would be welcome I think.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110207/3d34ae9e/attachment.html>