Re: deleting referenced data

On Tuesday 26 August 2003 18:55, Bruno Wolff III wrote:
> 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.

Ah - you're quite right Bruno. That's the approach I'd take. Andreas - take
care with simultaneous adding/removal in the relations table - that could
lead to an unexpected failure unless you make sure you're using serializable
transaction level.

--
Richard Huxton
Archonet Ltd