Re: cascade delete

Well I did google and got that delete cascade DDL for postgres. I tried it
using odbc and jdbc but didn't worked.

-----Original Message-----
From: Dave Cramer [mailto:pg(at)fastcrypt(dot)com]
Sent: 16 February 2004 15:03
To: Bhushan Bhangale
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] cascade delete

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

________________________________________________________________________
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
________________________________________________________________________

________________________________________________________________________
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
________________________________________________________________________