Re: DECLARE doesn't set/reset sqlca after DECLARE cursor - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: DECLARE doesn't set/reset sqlca after DECLARE cursor
Date
Msg-id 20090814075903.GB21414@feivel.credativ.lan
Whole thread Raw
In response to Re: DECLARE doesn't set/reset sqlca after DECLARE cursor  (Boszormenyi Zoltan <zb@cybertec.at>)
Responses Re: DECLARE doesn't set/reset sqlca after DECLARE cursor  (Boszormenyi Zoltan <zb@cybertec.at>)
List pgsql-hackers
On Thu, Aug 13, 2009 at 05:55:53PM +0200, Boszormenyi Zoltan wrote:
> Okay, so it's a declarative command. But if we're in a function,
> we should still emit a call to ecpg_init, to be able to follow

No, either it is declarative or it is not, but I don't see a reason for
different behaviour depending on where the command is located.

> the Informix behaviour. We can limit it it compat mode, though.

So let's first figure out exactly how Informix handles things. Zoltan, do you
have access to esql the Informix precompiler? If so, please run two simple
tests, one with just a DECLARE statement and one with a DECLARE statement in a
function and post the results please.

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
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: CommitFest 2009-07: Remaining Patches
Next
From: Magnus Hagander
Date:
Subject: Re: pg_hba.conf: samehost and samenet