From: Michael Fuhr <mike@fuhr.org>
To: Christian Kindler <christian.kindler@gmx.net>
Cc: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Returnd Refcurser (<unnamed portal x> not fetchable
Date: Fri, 10 Aug 2007 00:31:03 -0600
Message-ID: <20070810063103.GA7903@winnie.fuhr.org> (raw)
In-Reply-To: <20070810061628.206070@gmx.net>
References: <20070810061628.206070@gmx.net>
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
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: mike@fuhr.org, christian.kindler@gmx.net, penchalaiahp@infics.com
Subject: Re: Returnd Refcurser (<unnamed portal x> not fetchable
In-Reply-To: <20070810063103.GA7903@winnie.fuhr.org>
* 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