Re: how to inherits the references...

From: frederik nietzsche <nietzsche_psql(at)yahoo(dot)it>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: how to inherits the references...
Date: 2002-07-12 10:29:58
Message-ID: 20020712102958.36531.qmail@web12904.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.
If this is the only way, I'm going to use it, but I'm
not really satisfied by it...

ciao
danilo

> 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.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

______________________________________________________________________
Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità.
http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Luis Alberto Amigo Navarro 2002-07-12 11:37:47 Re: [HACKERS] please help on query
Previous Message Ahti Legonkov 2002-07-12 09:24:01 rules / triggers on insert. why after?