Mail-Followup-To: pgsql-sql@postgresql.org
To: pgsql-sql@postgresql.org
From: Tim Landscheidt <tim@tim-landscheidt.de>
Subject: Re: Can i force deletion of dependent rows?
Date: Sat, 13 Feb 2010 07:05:59 +0000
Organization: <URI:http://www.tim-landscheidt.de/>
Lines: 23
Message-ID: <m3fx55linc.fsf@passepartout.tim-landscheidt.de>
References: <6caee9521002120424l27ec8d3eq3b69522d0a773686@mail.gmail.com>
	<6caee9521002122211q7e4fd2fcj1a0489fd64dc204a@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Mail-Copies-To: never
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
Cancel-Lock: sha1:Vo0MSG3FO+fv3DgqiOcGineQR4E=

Shruthi A <shruthi.iisc@gmail.com> wrote:

> I have 2 tables (A and B) where the table B has a foreign key reference to
> table A.   Like this:

> create table A (x int primary key);
> create table B (y int primary key, z int references A (x) );

> As you can see, i've not specified any further 'on delete' clause to the
> foreign key constraint like 'on delete cascade' or 'on delete restrict' or
> 'on delete set null' or 'on delete set default'.   This means that the
> default behavior is followed ie 'on delete restrict' holds by default.

> Now I want to delete a particular row from table A.  Is there any way I can
> force deletion of all the dependent rows in table B?

> Note that the tables have already been created in the above manner and
> populated.  I want to do this deletion through DML only ie without any
> change in the table definition.

"DELETE FROM B WHERE z = 'your x';"?

Tim