Re: deleting referenced data

From: Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: deleting referenced data
Date: 2003-08-26 22:09:34
Message-ID: 3F4BDA9E.7040102@physik.uni-erlangen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruno Wolff III wrote:

>On Tue, Aug 26, 2003 at 18:34:04 +0100,
> Richard Huxton <dev(at)archonet(dot)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?

Regards

Andreas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-08-26 22:10:35 Re: Best tweak for fast results.. ?
Previous Message Christopher Browne 2003-08-26 22:05:53 Re: Buglist