Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

inheritance is madness



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group