Re: confusing inheritance

On Mon, 4 Mar 2002, Andreas F. wrote:

> I started pgAdmin and entered something like
>
> TABLE myObjects (
> ObjectID int4 PRIMARY KEY,
> createdOn timestamp,
> createdByUserID int4
> )
>
> then
>
> TABLE myTerminatedObjects (
> validFrom timestamp,
> validUntil timestamp
> ) INHERITS myObjects
>
> Obviously myTerminatedObjects stores it's values of inherited fields in
> the tablespace of myObjects breaking myObjects integrity without
> PostgreSQL complainig about.
> Am I right ?
>
> And myTerm... inherits the field "ObjectID" but not in the function as
> primary key so it has no key at all ?
> At least MS-Access 2K told me so.
>
>
> May someone give me a pointer to whats going on, please ?

Unique, primary and foreign keys do not currently inherit to child
tables which causes the behavior you were seeing.