From: Wiebe Cazemier <halfgaar@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: Primary key reference count
Date: Wed, 19 Apr 2006 17:00:19 +0200
Message-ID: <e25ja3$d1h$1@sea.gmane.org> (raw)
References: <e258pv$5fc$1@sea.gmane.org>
<20060419130932.GG3828@webserv.wug-glas.de>
<e25e6v$om6$1@sea.gmane.org>
On Wednesday 19 April 2006 15:33, Wiebe Cazemier wrote:
> Either I'm blind, or this is not what I'm looking for. I need to know the
> amount of references _to_ a primary key. If you have a customer with two
> orders and one invoice, the reference count for the primary key of the
> custormer would be 3.
>
> I need to know if I can delete rows which are not referenced anywhere,
> without catching the relational constraint exception. The reason I can't
> catch the exception, is that I want the exception to arrive at my application
> and/or tests.
Never mind. I found another solution.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: halfgaar@gmx.net
Subject: Re: Primary key reference count
In-Reply-To: <e25ja3$d1h$1@sea.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox