| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | 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-27 07:07:14 |
| Message-ID: | 200308270807.14401.dev@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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?
Those are basically your two options.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Becker | 2003-08-27 07:10:58 | Re: Books for PostgreSQL? |
| Previous Message | Shridhar Daithankar | 2003-08-27 07:04:54 | Re: 7.4b1 vs 7.3.4 performance |