Re: is the sqlca.sqlabc value unique for each response type

From: Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
To: reid(dot)thompson(at)ateb(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is the sqlca.sqlabc value unique for each response type
Date: 2002-11-21 08:13:18
Message-ID: 20021121091318.757ba208.christoph.dalitz@hs-niederrhein.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Date: Wed, 20 Nov 2002 22:40:59 -0500
> From: Reid Thompson <reid(dot)thompson(at)ateb(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2002-11-21 08:16:13 Re: double quotes around table and column names
Previous Message WangYuan 2002-11-21 07:45:31 How can I view the content of Logs?