Re: return next and pl/perl

----- Original Message -----
From: "Eric E" <whalesuit(at)bonbon(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, June 10, 2005 7:24 PM
Subject: [GENERAL] return next and pl/perl

> Hi all,
> I'm working on implementing a function in PL/PERL that will ready
> many rows. As such I'd like to use return_next to keep memory usage
> down. When I call return next, I get the following error message:
>
> ERROR: error from Perl function: Can't call method "return_next" on
> unblessed reference at (eval 18) line 25.
>
> likewise if I use spi_return_next:
> ERROR: error from Perl function: Can't call method "spi_return_next" on
> unblessed reference at (eval 16) line 25.
>
> After some Google and list searching, I inferred that spi_return_next
> may not be implemented? Is this correct? If so, is there a workaround?

There is no workaround that I know of. See here:

http://www.postgresql.org/docs/8.0/static/plperl-missing.html

It's a known limitation.

Sean