On Sun, Aug 2, 2009 at 6:26 PM, Janos Erdelyi<[email protected]> 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" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
