Re: Problems with variable cursorname in ecpg

Michael Meskes <meskes@postgresql.org>

From: Michael Meskes <meskes@postgresql.org>
To: Boszormenyi Zoltan <zb@cybertec.at>
Cc: Michael Meskes <meskes@postgresql.org>, PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2010-03-31T11:13:00Z
Lists: pgsql-hackers
On Wed, Mar 31, 2010 at 10:35:31AM +0200, Boszormenyi Zoltan wrote:
> > I think we should  make the error message/documentation a little bit clearer as
> > people have stumbled over it.
> 
> Yes, we need to document it.

I changed the error message and documented a possible improvement in the TODO list.

> I think you forget that in this case, only global variables are
> usable in the DECLARE in this case, no local variables in
> functions preceding the DECLARE are visible to it.

I thought about not allowing variables in declare statements that are outside a
function. Do you think it makes sense to allow those? Forbidding these right
now would give us more headroomfor future development.

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
ICQ 179140304, AIM/Yahoo/Skype michaelmeskes, Jabber meskes@jabber.org
VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL