[Pgpool-hackers] currval() and lastval() should be in black_function_list

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jan 11 09:09:32 UTC 2011


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


More information about the Pgpool-hackers mailing list