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

2006-04-19 Thread Kris Jurka
On Wed, 19 Apr 2006, surabhi.ahuja wrote: 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, See PQresultErrorField http://www.po

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

2006-04-18 Thread surabhi.ahuja
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

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

2006-04-17 Thread Kris Jurka
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 Jurk

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

2006-04-17 Thread surabhi.ahuja
i am working with PostgreSQL 8.0.0   and the programming lang used is java   i have a stored procedure which inserts a row in a table   to this stored procedure i pass the values which have to be inserted in that row.   now, i execute this query(which is a call to stored procedure)   this execut