Skip site navigation (1) Skip section navigation (2)

Re: No Exception thrown when there is a constraint violation, and delete fails

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: No Exception thrown when there is a constraint violation, and delete fails
Date: 2004-03-03 09:14:34
Message-ID: 20040303091434.C24535@bacon (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 02/03/2004 21:41 Nicholas Veeser wrote:
> 
> I am trying to do a delete, and there seems to be a constraint violation.
> Fine, but why does it not send an exception to let me know this.
> I mean, nothing happens. Not even a warning.
> 
> Is there something I need to turn on to find constraint violations as
> exceptions?
> 
> 
> Code:
> Connection c = DriverManager.getConnection(
> c.setAutoCommit(true);
> 	 
> PreparedStatement pst = c.prepareStatement("delete from queue where
> id=?");
> pst.setInt(1, 850);			 
> pst.executeUpdate();
> 			 
> c.close();
> 
> 
> Exception:
> None, not a thing.
> 
> 
> Error Log:
> 
> ERROR:  update or delete on "queue" violates foreign key constraint
> "fkd73c6034ba977309" on "branch_queue"
> DETAIL:  Key (id)=(850) is still referenced from table "branch_queue".

It works for me on every version of PostgreSQL I've tried it on (7.1 
onwards). 
-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

In response to

pgsql-jdbc by date

Next:From: Sean ElliottDate: 2004-03-03 10:33:27
Subject: Passing date and smallint (etc) parameters to functions from Java
Previous:From: AkashaDate: 2004-03-03 08:34:47
Subject: miss decoding issue in pg73jdbc2.jar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group