On Thu, Feb 25, 2016 at 8:53 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> But if the user says
>> they want to PREPARE the query, they are probably not going to fetch
>> all rows.
>
> After PREPARE, user will execute the statement using EXECUTE and
> I don't see how user can decide number of rows to fetch which can
> influence the execution. Can you please elaborate your point more
> and what is your expectation for the same?
Argh. I'm getting confused between prepared statements and cursors.
So if the user does PREPARE followed by EXECUTE, then that is OK. The
problem is only if they use DECLARE .. CURSOR FOR, which your patch
doesn't affect.
So, committed.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company