| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Boszormenyi Zoltan <zb(at)cybertec(dot)at> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Michael Meskes <meskes(at)postgresql(dot)org>, Noah Misch <noah(at)leadboat(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
| Subject: | Re: Modify the DECLARE CURSOR command tag depending on the scrollable flag |
| Date: | 2013-11-28 08:55:49 |
| Message-ID: | 20131128085549.GA16944@feivel.credativ.lan |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Nov 28, 2013 at 09:04:17AM +0100, Boszormenyi Zoltan wrote:
> >>Well, technically, unspecified means NO SCROLL according to the SQL
> >>standard. A lot of applications in ECPG are ported from other systems,
That means by automatically adding a literal NO SCROLL to the command we obey
standard, right? That's fine by me.
> >behavior applies, but it might break existing apps that were unknowingly
> >relying on a simple cursor being scrollable. OTOH any such app would be
> >subject to breakage anyway as a result of planner changes, so it's hard to
> >complain against this, as long as it's happening in a major version
> >update.
Ported applications might be in the same boat. I'm not sure if all other DBMSs
stick with the standard if nothing is specified. So again, adding it might help
make it clearer.
> Anyway, is explicitly adding NO SCROLL the preferred solution for everyone?
+1 from me.
Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
Jabber: michael.meskes at gmail dot com
VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2013-11-28 09:20:53 | Re: [GENERAL] pg_upgrade ?deficiency |
| Previous Message | Boszormenyi Zoltan | 2013-11-28 08:04:17 | Re: Modify the DECLARE CURSOR command tag depending on the scrollable flag |