Re: is the sqlca.sqlabc value unique for each response type - Mailing list pgsql-general

From Christoph Dalitz
Subject Re: is the sqlca.sqlabc value unique for each response type
Date
Msg-id 20021121091318.757ba208.christoph.dalitz@hs-niederrhein.de
Whole thread Raw
In response to is the sqlca.sqlabc value unique for each response type  (Reid Thompson <reid.thompson@ateb.com>)
List pgsql-general
> Date: Wed, 20 Nov 2002 22:40:59 -0500
> From: Reid Thompson <reid.thompson@ateb.com>
>
> Are the values that are populated in sqlca.sqlabc unique to response
> type?  IE, when i get a failure for 'ERROR:  Cannot insert a duplicate
> key into unique index "myindexname"' will the sqlca.sqlabc value always
> be the same?
>
> I'm looking for a way to determine if my failure is of this type w/o
> having to to a string compare on the error message.
>
Why don't you check sqlca.sqlcode (or in SQL92: SQLCODE)?
It should contain a specific error code.

Christoph Dalitz

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: &main::execute undefined?
Next
From: Mike Mascari
Date:
Subject: Re: double quotes around table and column names