Date: Fri, 12 Jul 2002 07:03:28 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: =?iso-8859-1?q?frederik=20nietzsche?= <nietzsche_psql@yahoo.it>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: how to inherits the references...
In-Reply-To: <20020712102958.36531.qmail@web12904.mail.yahoo.com>
Message-ID: <20020712070009.U6410-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Fri, 12 Jul 2002, [iso-8859-1] frederik nietzsche wrote:

> ok, thanks for the (double: two mails ;) ) help, but
> in this way when I insert a record in a child table,
> the key must be already present in the "sigles" table,
> otherwise it breaks the reference and doesn't insert
> anything.
> In order to use this solution I must create a set of
> function that when I want to insert something in a
> child tables it automatically insert BEFORE, the sigle
> in the "sigles" table and THEN insert the values in
> the child table.

A before trigger to insert into the key table would
probably work.  Another advantage to this sort of thing
is that you could probably actually guarantee uniqueness
of your key across the entire inheritance hierarchy
which you can't otherwise.

> If this is the only way, I'm going to use it, but I'm
> not really satisfied by it...

Inheritance is only marginally useful right now.