cascade delete

From: Bhushan Bhangale <bbhangale(at)Lastminute(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: cascade delete
Date: 2004-02-16 14:49:09
Message-ID: C9590F897BFAD7119E63000BCD682083C66DFB@lmnukpriv.lastminute.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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
________________________________________________________________________

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-02-16 15:03:04 Re: cascade delete
Previous Message Warren Little 2004-02-15 23:51:21 Re: idle in transaction