Thanks .
in java i can catch SQL
Exception,
what is the way to
capture such exception in Cpp,
are there any examples available for
this?
right now in cpp, i do this
rStatus = PQresultStatus(result);
but what is the specific error code, how to get that,
thanks,
regards
Surabhi
From: Kris Jurka
[mailto:books@xxxxxxxxxx]
Sent: Tue 4/18/2006 4:43 AM
To: surabhi.ahuja
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] catch SQLException, error code for Foeign key violation,
Sent: Tue 4/18/2006 4:43 AM
To: surabhi.ahuja
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] catch SQLException, error code for Foeign key violation,
***********************
Your mail has been scanned by
InterScan VirusWall.
***********-***********
On Mon, 17
Apr 2006, surabhi.ahuja wrote:
> The question is that is from this
SQLException can i detect if it is a
> foreign key
violation,
>
You should check the value of
SQLException.getSQLState() against this
table:
http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html
Kris
Jurka
