Quick Links

BUG #3961: ecpg lacks SQLSTATE macro definition

Lists:	pgsql-bugs

From:	"Christoph Dalitz" <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
To:	pgsql-bugs(at)postgresql(dot)org
Subject:	BUG #3961: ecpg lacks SQLSTATE macro definition
Date:	2008-02-14 11:09:11
Message-ID:	200802141109.m1EB9BIh099592@wwwmaster.postgresql.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-bugs

The following bug has been logged online:

Bug reference: 3961
Logged by: Christoph Dalitz
Email address: christoph(dot)dalitz(at)hs-niederrhein(dot)de
PostgreSQL version: 8.2.6
Operating system: Linux
Description: ecpg lacks SQLSTATE macro definition
Details:

While ecpg defines the (deprecated) SQLCODE, it does not define the macro
SQLSTATE, even though the documentation say, that this latter macro should
be used and which values it can take.

Please add a macro definition

#define SQLSTATE sqlca.sqlstate

in ecpglib.h like for SQLSTATE to be compatible with the SQL standard.

Thanks,

Christoph

From:	Michael Meskes <meskes(at)postgresql(dot)org>
To:	Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
Cc:	pgsql-bugs(at)postgresql(dot)org
Subject:	Re: BUG #3961: ecpg lacks SQLSTATE macro definition
Date:	2008-02-14 12:39:54
Message-ID:	20080214123954.GA9582@feivel.credativ.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	Postg토토SQL : Postg토토SQL 메일 링리스트 : 2008-02-14 이후 PGSQL-BUGS 12:39

Hallo Christoph,

On Thu, Feb 14, 2008 at 11:09:11AM +0000, Christoph Dalitz wrote:
> Description: ecpg lacks SQLSTATE macro definition

Thanks for reporting this oversight. I added the definition to CVS, also
for 8.2.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Michael Meskes <meskes(at)postgresql(dot)org>
Cc:	Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>, pgsql-bugs(at)postgresql(dot)org
Subject:	Re: BUG #3961: ecpg lacks SQLSTATE macro definition
Date:	2008-02-14 16:13:53
Message-ID:	9028.1203005633@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-bugs

Michael Meskes <meskes(at)postgresql(dot)org> writes:
> Hallo Christoph,
> On Thu, Feb 14, 2008 at 11:09:11AM +0000, Christoph Dalitz wrote:
>> Description: ecpg lacks SQLSTATE macro definition

> Thanks for reporting this oversight. I added the definition to CVS, also
> for 8.2.

Michael, we branched 8.3 yesterday, so you need a third commit if you
don't want people to see a regression from 8.2.7 to 8.3.x.

regards, tom lane

From:	Michael Meskes <meskes(at)postgresql(dot)org>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	Michael Meskes <meskes(at)postgresql(dot)org>, Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>, pgsql-bugs(at)postgresql(dot)org
Subject:	Re: BUG #3961: ecpg lacks SQLSTATE macro definition
Date:	2008-02-15 12:12:39
Message-ID:	20080215121239.GB13568@feivel.credativ.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	Postg토토 핫SQL : Postg토토 핫SQL 메일 링리스트 : 2008-02-15 이후 PGSQL-BUGS 12:12

On Thu, Feb 14, 2008 at 11:13:53AM -0500, Tom Lane wrote:
> Michael, we branched 8.3 yesterday, so you need a third commit if you
> don't want people to see a regression from 8.2.7 to 8.3.x.

Thanks for the note, just committed to 8.3 branch as well.