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

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>, Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
Subject: Re: DECLARE doesn't set/reset sqlca after DECLARE cursor
Date: 2009-08-14 19:09:19
Message-ID: 4A85B65F.7080805@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Meskes írta:
> On Fri, Aug 14, 2009 at 01:02:07PM +0200, Boszormenyi Zoltan wrote:
>
>> Here are the two test files, with their preprocessed C output.
>> Indeed, Informix emits a function call for DECLARE CURSOR.
>> And it seems it's not legal to do this outside of a function.
>>
>
> Okay, thanks. I changed several things in your patch mainly due to chosing a
> slightly different way to reset the sqlca array and committed that change.
> Please test.
>

I looked at the committed change, and it works
the same as my version, only the emitted call
is put into the compat library. According to the
regression tests, it works. Thanks. :-)

Best regards,
Zoltán Böszörményi

--
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics

----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2009-08-14 19:15:54 Re: Split-up ECPG patches
Previous Message Tom Lane 2009-08-14 18:57:37 More cruft left behind in doc directory