From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: frederik nietzsche <nietzsche_psql@yahoo.it>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: how to inherits the references...
Date: Fri, 12 Jul 2002 07:03:28 -0700 (PDT)
Message-ID: <20020712070009.U6410-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <20020712102958.36531.qmail@web12904.mail.yahoo.com>
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.
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: sszabo@megazone23.bigpanda.com, nietzsche_psql@yahoo.it
Subject: Re: how to inherits the references...
In-Reply-To: <20020712070009.U6410-100000@megazone23.bigpanda.com>
* 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