On Sun, Dec 13, 2009 at 11:44 PM, Jaime Casanova <[email protected]> wrote:
> create or replace function f1() returns integer as $$ > insert into t1 values(current_date); > select 1; > $$ language sql volatile; > > the insert executed as a side effect in the function f1() could be > sent to an slave instead of the master, something we can make to solve > this? Correct. pgpool-II has its limitations, as stated in the docs. Still, pgpool-II has methods to capture instructions such as the insert above and make sure the returned value in the master is propagated to the slave nodes. Not sure what it does when the insert is inside a function, though. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
