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

Re: cascade delete

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Bhushan Bhangale <bbhangale(at)Lastminute(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: cascade delete
Date: 2004-02-16 15:03:04
Message-ID: 1076943784.6785.128.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
Does this work in psql? The driver wouldn't do anything to interfere
with this.

Dave
On Mon, 2004-02-16 at 09:49, Bhushan Bhangale wrote:
> Hi,
> 
> I have following 2 tables in postgres DB. I created a cascade delete
> constraint on image_id column of accomm_images which is a foreign key from
> image tbale.
> 
> When I execute -> delete from accomm_images
> It should delete all the child records of image table as well. But its not
> happening.
> 
> CREATE TABLE image(
>     id 	        int4 NOT NULL,
>     url             int4 NOT NULL
> );
> 
> CREATE TABLE accomm_images(
>     accomm_id            int4 NOT NULL references accomm(id),
>     image_id             int4 NOT NULL references image(id) on delete
> cascade
> );
> 
> 
> Is there anything missing?
> 
> Thanks
> Bhushan
> 
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561


In response to

pgsql-jdbc by date

Next:From: Bhushan BhangaleDate: 2004-02-16 15:33:31
Subject: Re: cascade delete
Previous:From: Bhushan BhangaleDate: 2004-02-16 14:49:09
Subject: cascade delete

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