Received: from femail26.sdc1.sfba.home.com ([24.254.60.16]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8C1PI709335 for ; Tue, 11 Sep 2001 21:25:19 -0400 (EDT) (envelope-from kway@overtone.org) Received: from bean.overtone.org ([24.249.254.100]) by femail26.sdc1.sfba.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with ESMTP id <20010912012510.PIKO12095.femail26.sdc1.sfba.home.com@bean.overtone.org> for ; Tue, 11 Sep 2001 18:25:10 -0700 Received: by bean.overtone.org (Postfix, from userid 1001) id 2B0C05B5F0; Wed, 12 Sep 2001 01:25:09 +0000 (GMT) Date: Wed, 12 Sep 2001 01:24:35 +0000 From: Kevin Way To: Christof Glaser Subject: Re: table inheritance and foreign key troubles Message-ID: <20010912012435.B14176@bean.overtone.org> References: <20010911080452.A76783@bean.overtone.org> <20010911091250.B8DD213061@pinguin.gl.aser.de> <20010911104915.9400813098@pinguin.gl.aser.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010911104915.9400813098@pinguin.gl.aser.de>; from gcg@gl.aser.de on Tue, Sep 11, 2001 at 12:49:13PM +0200 Resent-From: kway@bean.overtone.org Resent-Date: Wed, 12 Sep 2001 01:25:09 +0000 Resent-To: pgsql-sql@postgresql.org Resent-Message-Id: <20010912012509.2B0C05B5F0@bean.overtone.org> X-Archive-Number: 200109/57 X-Sequence-Number: 4703 > 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