On Thu, Feb 25, 2016 at 8:53 AM, Amit Kapila <amit.kapil...@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 -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers