Re: deleting referenced data - Mailing list pgsql-general

From Richard Huxton
Subject Re: deleting referenced data
Date
Msg-id 200308270807.14401.dev@archonet.com
Whole thread Raw
In response to Re: deleting referenced data  (Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>)
List pgsql-general
On Tuesday 26 August 2003 23:09, Andreas Fromm wrote:
> Bruno Wolff III wrote:
> >On Tue, Aug 26, 2003 at 18:34:04 +0100,
> >  Richard Huxton <dev@archonet.com> wrote:
> >
> >
> >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.
>
> This is what I want to do, but my question is how can I easely now if
> there is someone referencing a certain record. Is it just possible by
> searching every table that could reference it or is there an other way
> of doing it without adding an reference count column?

Those are basically your two options.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: 7.4b1 vs 7.3.4 performance
Next
From: Christoph Becker
Date:
Subject: Re: Books for PostgreSQL?