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.