[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