inheritance is madness

From: "T W" <list(at)traviswellman(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: inheritance is madness
Date: 2007-09-21 05:11:11
Message-ID: ed53fec90709202211w2e77c541i64d779ebbdb98c0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello Gurus

I'm very surprised at the fact that primary keys are not inherited.
When trying to make foreign keys from a third table to a parent table,
the child table's data is not counted [I assume] due to this fact,
even if the child table has the same primary key. This is really
weird, considering a select from the parent table will return the
child table's data. Does anyone know of a hack to get this behavior to
change, and allow the third table to use a foreign key that references
child table data?

Thanks very much,
Travis

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2007-09-21 08:45:37 Re: inheritance is madness
Previous Message Sean Davis 2007-09-20 19:04:12 Re: selecting other schema's as the public one from php