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

[Tatsuo Ishii]

> 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?

You could add a comment in front of the SELECT query. For example,

/*REPLICATION*/SELECT your_pl_pgsql_function();

This will force the SELECT excutes on both nodes.
--
Tatsuo Ishii
SRA OSS, Inc. Japan