Re: how to inherits the references...

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: frederik nietzsche <nietzsche_psql(at)yahoo(dot)it>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: how to inherits the references...
Date: 2002-07-11 16:00:48
Message-ID: 20020711085735.H63911-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Thu, 11 Jul 2002, [iso-8859-1] frederik nietzsche wrote:

> as if the sigles where not in the "sigles" table, but
> it's there!
> it's probably because of the way in which psql threats
> the inheritance.
> my question is (finally): is there some workaround for
> this?? or: am I making some mistakes??

Foreign keys don't inherit to children table on either
the fk or pk side. Note also that the primary keys in
the above will not guarantee that sigle is unique
across the whole set, only across each table individually.

Pretty much the only workaround I know of is to make a table
with the key columns and have each of the tables in the
inheritance tree have its key columns reference that and anything
that wants to reference the inheritance tree references
the other table instead.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Manfred Koizar 2002-07-11 16:47:03 Re: [HACKERS] please help on query
Previous Message Jie Liang 2002-07-11 15:41:00 Re: pg_restore cannot restore index