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:t...@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 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
