Re: catch SQLException, error code for Foeign key violation,

["surabhi.ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>]

Title: Re: [GENERAL] catch SQLException, error code for Foeign key violation,

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(at)ejurka(dot)com]
Sent: Tue 4/18/2006 4:43 AM
To: surabhi.ahuja
Cc: pgsql-general(at)postgresql(dot)org
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