Re: cursors with prepared statements - Mailing list pgsql-general

From Bryn Llewellyn
Subject Re: cursors with prepared statements
Date
Msg-id C08CD8DD-1B09-433D-A90C-32F4A09615C3@yugabyte.com
Whole thread Raw
In response to Re: cursors with prepared statements  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements
List pgsql-general
> david.g.johnston@gmail.com wrote:
>
>> bryn@yugabyte.com wrote:
>>
>> I found this email from Peter Eisentraut:
>> https://www.postgresql.org/message-id/762cc764-74f0-13fb-77ed-16f91c90f40d%402ndquadrant.com
>>
>> It caused the 42601 error, « syntax error at or near “execute” ». So it looks like Peter’s patch hasn’t yet been
adopted.What is the likelihood that it will be adopted in a future version? 
>
> Closer to zero than one I'd say, given how that thread ended and not subsequent activity on the feature in the five
yearssince. 

Thanks. Shall I assume, too, that there’s no under-the-hood functionality for cursors, analogous to what happens with a
PL/pgSQLprogram at run-time, that does the moral equivalent of on-demand prepare for a cursor’s defining subquery? 


pgsql-general by date:

Previous
From: Arquimedes Aguirre
Date:
Subject: RE: FW: Error!
Next
From: Adrian Klaver
Date:
Subject: Re: FW: Error!