[Pgpool-general] pl/pgsql update function is just executed on one backend

[ACHA | Marco Wayop]

pgpool info:
version                         : pgpool-II version 2.1 - inamiboshi
replication mode            : true
load_balance_mode       : true
master_slave_mode       : false
parallel_mode                : false
amound of backends      : 3

Hi,

When calling a pl/pgsql function, trough pgpool, it seems to be executed on one backend only.
(perhaps due to the parralel query mode)

The pl/pgsql function however is updating, inserting and deleting several records causing the backends to be out of sync.

Any suggestions?

Thanks!
Marco Wayop
the Netherlands, Amsterdam