Hi, Le 11/01/2011 10:09, Tatsuo Ishii a écrit : > [...] > I realized that unless currval() and lastval() are not in > black_function_list, they are failing because of load balance. As you > know, those functions fail unless nextval() is called > beforehand. Consider following scenario: > > select nextval(); -- executed on primary because it's in black_function_list > select currval(); -- fails because executed on standby node > > So I will change docs and sample configuration files it is recommended > that currval() and lastval() are in the black_function_list. > > Comments or objections?
No objection. Seems a good addition to the docs. -- Guillaume http://www.postgresql.fr http://dalibo.com _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
