[Pgpool-general] Using SELECT + nextval + load balance with pgpool

Tatsuo Ishii ishii at sraoss.co.jp
Wed Sep 6 14:13:38 UTC 2006


> Hello,
> 
> On Wed, 2006-09-06 at 22:21 +0900, Tatsuo Ishii wrote:
> > Any idea?
> 
> What about teaching pgpool to ignore "SELECT nextval()" queries (and
> also setval, of course) while load balancing?

What if nextval() is in a user defined function? What if SELECT
nextval() is placed in subselect? What do you do with user defined
functions having side effects?
--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list