From: Christian Kindler <christian.kindler@gmx.net>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-sql@postgresql.org
Cc: penchalaiahp@infics.com
Subject: Re: Returnd Refcurser (<unnamed portal x> not fetchable
Date: Fri, 10 Aug 2007 08:35:28 +0200
Message-ID: <20070810063528.206050@gmx.net> (raw)
In-Reply-To: <20070810063103.GA7903@winnie.fuhr.org>
References: <20070810061628.206070@gmx.net>
<20070810063103.GA7903@winnie.fuhr.org>
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@fuhr.org>
An: Christian Kindler <christian.kindler@gmx.net>
CC: "Penchalaiah P." <penchalaiahp@infics.com>, pgsql-sql@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: christian.kindler@gmx.net, mike@fuhr.org, penchalaiahp@infics.com
Subject: Re: Returnd Refcurser (<unnamed portal x> not fetchable
In-Reply-To: <20070810063528.206050@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox