Re: table inheritance and foreign key troubles

From: Kevin Way <kevin(dot)way(at)overtone(dot)org>
To: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
Subject: Re: table inheritance and foreign key troubles
Date: 2001-09-12 01:24:35
Message-ID: 20010912012435.B14176@bean.overtone.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Miguel González 2001-09-12 07:51:46 Re: SQL Query
Previous Message Domingo Alvarez Duarte 2001-09-11 20:15:21 using LATIN1 ?