> Greets, > > PgPool II correctly redirects SELECT to the localhost, while sending > UPDATE/DELETE/INSERT to the master. > > However, it is sending the following to the master (even when master > weight is 0): > > DECLARE cursorname CURSOR WITH HOLD FOR SELECT * FROM tablename; > > I have several processes running at the moment, and I suspect the > following will also go to the wrong node: > > FETCH n FROM cursorname; > CLOSE cursorname; > > Is this expected behaviour, or should I try and fool it for the time being
Yeah, I think this is a bug. DECLARE without FOR UPDATE/SHARE should be able to load balance (FETCH, CLOSE as well). I have fixed the problem and committed to CVS HEAD. Please try. -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
