Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: catch SQLException, error code for Foeign key violation,
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: "surabhi.ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: catch SQLException, error code for Foeign key violation,
- Date: Mon, 17 Apr 2006 18:13:55 -0500 (EST)
- Message-id: <Pine(dot)BSO(dot)4(dot)63(dot)0604171812200(dot)11226(at)leary2(dot)csoft(dot)net>
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
- References:
- catch SQLException, error code for Foeign key violation,
- From: surabhi.ahuja
- catch SQLException, error code for Foeign key violation,
- Prev by Date: Re: tsearch partial word
- Next by Date: Re: plpgsql replication stored procedure
- Previous by thread: catch SQLException, error code for Foeign key violation,
- Next by thread: Re: catch SQLException, error code for Foeign key violation,
- Indexes: