Re: BUG #6583: for loop cursor

Hi Tom,

Well I thought I was running version "8.4.*" but it turned out to be "8.2.14" when I did a show server_version in pgAdminIII. So, is this a known issue?
Well I won't possibly be able to upgrade the version as its bundled with the DB. :-(

Cordially,
Biju George
UST Global | Trivandrum

________________________________

From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thu 4/12/2012 8:34 PM
To: Biju George (UST, IND)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #6583: for loop cursor

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