On Thu, August 28, 2008 6:22 pm, Henry wrote: > SELECT 1; DECLARE cursorname CURSOR WITH HOLD FOR SELECT * FROM tablename;
It looks like the following might be a work-around (I seem to recall this trick being mentioned somewhere by Tatsuo Ishii): /* SELECT */ DECLARE cursorname CURSOR WITH... /* SELECT */ FETCH 1000 FROM ... /* SELECT */ CLOSE cursorname; The NOP selects fool the parser to force it to the local node. I'll confirm once I've had some sleep. Cheers Henry _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
