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