[Pgpool-general] Load balancing read-write functions

[Nelson Correia]

Hi,I have a scenario   where I want to use Slony for master-slave replication and pgpool for load-balancing and where I have many functions with write commands. When using these functions I issue a command like "select * from somefunction(1, 'xpto')" and 'somefunction' will do several queries, being one of them an insert/update. How will pgpool load-balance this kind of queries? Is it able to see that it's not a read-only command and will send the command always only to the master? More generically, how did pgpool deal with functions and triggers?Thanks,Nelson  
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080529/6a0f0204/attachment.html