Hi, 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? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
