| 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.
| 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 |