Which one is the parent table?
If accomm_images is the parent, then make id reference it and cascade
delete.
Dave
On Mon, 2004-02-16 at 10:53, Bhushan Bhangale wrote:
> 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