From: Shruthi A <shruthi.iisc@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Can i force deletion of dependent rows?
Date: Sat, 13 Feb 2010 11:41:14 +0530
Message-ID: <6caee9521002122211q7e4fd2fcj1a0489fd64dc204a@mail.gmail.com> (raw)
In-Reply-To: <6caee9521002120424l27ec8d3eq3b69522d0a773686@mail.gmail.com>
References: <6caee9521002120424l27ec8d3eq3b69522d0a773686@mail.gmail.com>
Hello,
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.
Thanks,
Shruthi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shruthi.iisc@gmail.com
Subject: Re: Can i force deletion of dependent rows?
In-Reply-To: <6caee9521002122211q7e4fd2fcj1a0489fd64dc204a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox