Re: DECLARE doesn't set/reset sqlca after DECLARE cursor

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: DECLARE doesn't set/reset sqlca after DECLARE cursor
Дата
Msg-id 20090814075903.GB21414@feivel.credativ.lan
обсуждение исходный текст
Ответ на Re: DECLARE doesn't set/reset sqlca after DECLARE cursor  (Boszormenyi Zoltan <zb@cybertec.at>)
Ответы Re: DECLARE doesn't set/reset sqlca after DECLARE cursor  (Boszormenyi Zoltan <zb@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: CommitFest 2009-07: Remaining Patches
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_hba.conf: samehost and samenet