Re: Returnd Refcurser (<unnamed portal x> not fetchable

Ohhh Yes!

Thanks al lot. Sometimes you can't see the wood for the trees.

Thanks!
Chris

-------- Original-Nachricht --------
Datum: Fri, 10 Aug 2007 00:31:03 -0600
Von: Michael Fuhr <mike(at)fuhr(dot)org>
An: Christian Kindler <christian(dot)kindler(at)gmx(dot)net>
CC: "Penchalaiah P." <penchalaiahp(at)infics(dot)com>, pgsql-sql(at)postgresql(dot)org
Betreff: Re: [SQL] Returnd Refcurser (<unnamed portal x> not fetchable

> On Fri, Aug 10, 2007 at 08:16:28AM +0200, Christian Kindler wrote:
> > select * from getfoo('M');
> > -- fetch all in '<unnamed portal 14>';
> >
> > ERROR: syntax error at or near "'<unnamed portal 14>'" at character 15
>
> The cursor name is an identifier so use double quotes instead of
> single quotes. Also, when using non-holdable cursors you'll need
> to be in a transaction block.
>
> begin;
> select * from getfoo('M');
> fetch all in "<unnamed portal 14>";
> commit;
>
> --
> Michael Fuhr

--
cu
Chris

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer