Re: return next and pl/perl

----- Original Message -----
From: "Eric E" <whalesuit@bonbon.net>
To: <pgsql-general@postgresql.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