Re: Primary key inheritance problem - Mailing list pgsql-general

From Matthew M Davis
Subject Re: Primary key inheritance problem
Date
Msg-id 20040829170739.GA13465@localhost
Whole thread Raw
In response to Re: Primary key inheritance problem  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: Primary key inheritance problem  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
On Sunday 29 August at 12:34pm, Oliver Elphick had this to say:

> Primary and foreign key constraints are not inherited.  This is a defect
> in the current system.

It almost seems like a FEATURE to me, since it creates a different and
easy way to create one-to-many relationships.  But I didn't use it,
since the documentation says this is a Bad Thing that may be fixed
some day.  If the child table inherits the primary key constraint from
the parent, why not just put it in the same table?

--

Matthew M Davis
<mmd@teledavis.com>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Migrating between versions. Problem with regexp
Next
From: Oliver Elphick
Date:
Subject: Re: Primary key inheritance problem