Re: deleting referenced data - Mailing list pgsql-general

From Andreas Fromm
Subject Re: deleting referenced data
Date
Msg-id 3F4BDA9E.7040102@physik.uni-erlangen.de
Whole thread Raw
In response to Re: deleting referenced data  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: deleting referenced data  (Richard Huxton <dev@archonet.com>)
Re: deleting referenced data  (Jonathan Bartlett <johnnyb@eskimo.com>)
Re: deleting referenced data  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
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?

Regards

Andreas


pgsql-general by date:

Previous
From: javier garcia - CEBAS
Date:
Subject: problem with upgrading 7.2 -> 7.3.4
Next
From: Christian von Kietzell
Date:
Subject: Database recovery after fs crash