On Mon, Aug 3, 2009 at 3:06 AM, Tatsuo Ishii<[email protected]> wrote:

> Since pgpool does not analyze codes inside a function, it cannot know
> if you actually issue INSERT or not. A workaround for this is, add a
> bogus comment to the SELECT statement:
>
> /* NO LOAD BALANCE */SELECT your_function();
>
> This will let pgpool beleive it's not a load balancable SELECT query.

That is the one I tried to mention but had forgotten about it :)

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to