> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
