[Pgpool-general] INSERTs in FUCTIONS are not replicating

[Jaume Sabater]

On Mon, Aug 3, 2009 at 3:06 AM, Tatsuo Ishii<ishii at sraoss.co.jp> 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"