Skip site navigation (1) Skip section navigation (2)

Re: BUG #1592: "with hold" cursor problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gabor Berenyi" <ber_(at)freemail(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1592: "with hold" cursor problem
Date: 2005-04-10 20:10:29
Message-ID: 13046.1113163829@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Gabor Berenyi" <ber_(at)freemail(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-04-10 20:12:22
Subject: Re: BUG #1590: Comparison Operation with Strings
Previous:From: Tom LaneDate: 2005-04-10 20:07:35
Subject: Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group