Re: table inheritance and foreign key troubles - Mailing list pgsql-sql

> PG cannot inherit primary keys or unique constraints, I recall now. So  
> you need to ensure uniqueness for users.node_id:
> CREATE TABLE users (
>   node_id   INT4 UNIQUE,
>   ....
> ) INHERITS (node );

Thank you so much, this is where the flaw in my logic was hiding.  Your
suggestion worked perfectly.

Kevin Way