[Pgpool-general] INSERTs in FUCTIONS are not replicating

[J. Carlos Muro]

2009/8/2 Janos Erdelyi <janos.erdelyi at gmail.com>

> when i issue inserts, updates, deletes, selects - i get the expected
> results on all attached nodes.
>
> however when i do inserts from within functions, the insert only occurs on
> the master node.


AFAIK, the function should have to get executed in every node.. Another
question is, which the result is to be..
For example,"select 2+2;" will return "4" on every node. But, " select
now();" will return different values...

Even (from the docs) as of pgpool-II 2.2, it detects tables with serials,
and makes auto locks..
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090803/8ebeac1e/attachment.html>