Re: cascade delete - Mailing list pgsql-jdbc
From | Bhushan Bhangale |
---|---|
Subject | Re: cascade delete |
Date | |
Msg-id | C9590F897BFAD7119E63000BCD682083C66E0C@lmnukpriv.lastminute.com Whole thread Raw |
In response to | cascade delete (Bhushan Bhangale <bbhangale@Lastminute.com>) |
Responses |
Re: cascade delete
(Dave Cramer <pg@fastcrypt.com>)
|
List | pgsql-jdbc |
I want other way round. -----Original Message----- From: Dave Cramer [mailto:pg@fastcrypt.com] Sent: 16 February 2004 15:51 To: Bhushan Bhangale Cc: pgsql-jdbc@postgresql.org Subject: Re: [JDBC] cascade delete It works the other way around, If you delete from images, then the corresponding entry from accomm_images will be deleted. DAve On Mon, 2004-02-16 at 10:33, Bhushan Bhangale wrote: > 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@fastcrypt.com] > Sent: 16 February 2004 15:03 > To: Bhushan Bhangale > Cc: pgsql-jdbc@postgresql.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 ________________________________________________________________________
pgsql-jdbc by date: