| 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: | Whole Thread | Raw Message | 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 |