Re: possible to DELETE CASCADE?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Miles Keaton <mileskeaton(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: possible to DELETE CASCADE?
Date: 2004-12-30 21:07:51
Message-ID: 20041230210751.GA28934@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Dec 30, 2004 at 11:40:21 -0800,
Miles Keaton <mileskeaton(at)gmail(dot)com> wrote:
> On Thu, 30 Dec 2004 11:10:38 -0800, I wrote:
> > Is it possible for a query to delete a record and all of its
> > foreign-key dependents?
>
>
> Sorry - to be more clear : I like having my foreign keys RESTRICT from
> this kind of cascading happening automatically or accidently.
>
> So I'm looking for a query that could force it to happen, if truly intended.

Patient: Doctor, it hurts when I do this.
Doctor: Then stop doing that.

Maybe you should only allow a special account to be able to delete from
the parent table and control access to that special account. Depending
on what kind of accidents you are trying to prevent, this may help.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Cox 2004-12-30 21:19:05 Postgresql website issues.
Previous Message Timothy Perrigo 2004-12-30 20:32:05 syntax for inserting unicode character literal