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
________________________________________________________________________