Home > mailing lists

catch SQLException, error code for Foeign key violation, - Mailing list pgsql-general

From	surabhi.ahuja
Subject	catch SQLException, error code for Foeign key violation,
Date	April 17, 2006 12:16:17
Msg-id	8626C1B7EB748940BCDD7596134632BE398675@jal.iiitb.ac.in Whole thread Raw
Responses	Re: catch SQLException, error code for Foeign key violation,
List	pgsql-general

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 execute query is in a try block

and i catch SQL exception for it.

The question is that is from this SQLException can i detect if it is a foreign key violation,

i saw there is a method on SQLException,

e.getErrorCode, is ther specific error code for Foreign Key violation,

thanks,

regards

Surabhi

From: "Danish"
Date: 17 April 2006, 12:06:29
Subject: tsearch2 installation problem

From: Devrim GUNDUZ
Date: 17 April 2006, 12:42:45
Subject: Question about partitioning