Re: Inheritance and Constraints

On Wed, 16 Jul 2003, Andrew Vit wrote:

> CREATE TABLE products (
>   id   serial      NOT NULL PRIMARY KEY,
>   name varchar(64) NOT NULL,
> );
>
> CREATE TABLE thing_1 (
>   foo  smallint,
>   bar  text,
> ) inherits (products);
>
> CREATE TABLE grading (
>   thingid  int NOT NULL REFERENCES thing_1 (id),   --this is the problem.
>   userid   int NOT NULL REFERENCES users (id),
>   vote     smallint NOT NULL,
>   PRIMARY KEY (thingid, userid)
> )

Is it complaining that there isn't a unique index on thing_1(id)?  Primary
keys don't inherit currently, so there's no constraint guaranteeing
uniqueness on thing_1.id.