Hi Tom,
=20
Well I thought I was running version "8.4.*" but it turned out to be "8.2.1=
4" when I did a show server_version in pgAdminIII. So, is this a known issu=
e?=20
Well I won't possibly be able to upgrade the version as its bundled with th=
e DB. :-(
=20
Cordially,
Biju George
UST Global | Trivandrum
________________________________
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thu 4/12/2012 8:34 PM
To: Biju George (UST, IND)
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6583: for loop cursor=20
I wrote:
> Works for me in 8.4.11 (after correcting record_var.id -> record_var.pid
> at line 6). Maybe you need to update to some more recent version than
> 8.4.0.
Actually, I do get the described behavior when trying this in 8.3,
which does not have FOR-over-cursor. So maybe the more appropriate
question is whether you're really running 8.4.anything.
regards, tom lane