| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: deleting referenced data |
| Date: | 2003-08-26 17:55:42 |
| Message-ID: | 20030826175542.GA17741@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Aug 26, 2003 at 18:34:04 +0100,
Richard Huxton <dev(at)archonet(dot)com> wrote:
> On Tuesday 26 August 2003 15:06, Andreas Fromm wrote:
> >
> > When I delete a record of the table realtions I also want to delete the
> > record on the data-tables if there is no other record referencing them.
> > How can I do this?
>
> You want to add "ON DELETE CASCADE" to the REFERENCES... clause.
> See the SQL reference for full syntax details.
I don't think that is what he wants. He seems to want to go in the other
direction. That is going to require custom triggers and probably adding a
reference count column to data-tables.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | darren | 2003-08-26 17:59:29 | Re: pl/tcl trigger question |
| Previous Message | Robby Russell | 2003-08-26 17:53:16 | Re: Fwd: installing postgres7.3.4 problem II |