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

[Guillaume Lelarge]

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