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.