Re: BUG #1592: "with hold" cursor problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1592: "with hold" cursor problem
Date
Msg-id 13046.1113163829@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1592: "with hold" cursor problem  ("Gabor Berenyi" <ber_@freemail.hu>)
List pgsql-bugs
"Gabor Berenyi" <ber_@freemail.hu> writes:
> begin;
> declare t cursor with hold for select function() as x from R;
> commit;

> Documentation says that the rows represented by a held cursor are copied
> into a temporary file or memory area, but they are not, if they are results
> of a function call. Instead, "commit" aborts the connection.

Works for me.  Could we see a complete, self-contained example?
In particular I suppose that the details of function() might be
relevant.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
Next
From: Tom Lane
Date:
Subject: Re: BUG #1590: Comparison Operation with Strings