[Pgpool-general] DECLARE cursorname not being redirected correctly

[Tatsuo Ishii]

> 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