BUG #1850: parameter WITH HOLD (of function DECLARE CURSOR) not acepted inside CREATE FUNCTION.

From: "Danilo Barbosa" <dusb(at)airgate(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1850: parameter WITH HOLD (of function DECLARE CURSOR) not acepted inside CREATE FUNCTION.
Date: 2005-08-26 17:12:22
Message-ID: 20050826171222.CCD56F1557@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1850
Logged by: Danilo Barbosa
Email address: dusb(at)airgate(dot)com(dot)br
PostgreSQL version: 8.1
Operating system: LINUX
Description: parameter WITH HOLD (of function DECLARE CURSOR) not
acepted inside CREATE FUNCTION.
Details:

CREATE OR REPLACE FUNCTION teste2()
RETURNS refcursor AS
$BODY$DECLARE
ref CURSOR WITH HOLD FOR SELECT * FROM tb_ponto;
BEGIN
OPEN ref;
RETURN ref;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION teste2() OWNER TO aes_jacui;

The same DECLARE works outside the CREATE FUNCTION.

thank you!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-08-26 17:16:05 Re: Serialization errors on single threaded request stream
Previous Message Kevin Grittner 2005-08-26 17:03:02 Re: Serialization errors on single threaded request