[Pgpool-general] INSERTs in FUCTIONS are not replicating

[Jaume Sabater]

On Sun, Aug 2, 2009 at 6:26 PM, Janos Erdelyi<janos.erdelyi at gmail.com> wrote:

> however when i do inserts from within functions, the insert only occurs on
> the master node.
>
> the table has a SERIAL primary key, and i expect that this can be an issue
> with synchronizing, but shouldn't the insert at least happen on all nodes?

It depends on how you call the function, but most probably pgpool-II
is executing/calling the function in one node only, therefore what the
function does before it returns an exit value to pgpool-II happens
only in that node.

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

"Ubi sapientas ibi libertas"