Tom Lane wrote:
> ncm@zembu.com (Nathan Myers) writes:
> > Now that 7.1 is safely in the can, is it time to consider
> > this patch?
>
> Not till we've forked the tree for 7.2, which is probably a week or so
> away...
IIRC the patch only provides the syntax for CURSOR to PL/pgSQL. Not real cursor support on the SPI level.
So it's still the same as before, the backend will try to suck up the entire resultset into the SPI tuple table
(that'smemory) and die if it's huge enough.
What we really need is an improvement to the SPI manager to support cursor (or cursor like behaviour through
repeated executor calls).
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com