X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 23F889FA6B5 for ; Thu, 10 Aug 2006 19:36:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 87576-08 for ; Thu, 10 Aug 2006 19:36:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id 1D71B9FB27E for ; Thu, 10 Aug 2006 19:36:15 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id n25so938684pyg for ; Thu, 10 Aug 2006 15:36:14 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=i15e4ZZAJJO0ZKtvtUDlIrhYxabuoR1eZfFXYxgfWZTBzzEbabDL3Mkk+cVcVzvvub1i6j2xPAYTZQr3ObW7GtlrEb/zNx4LgZuTTLgLFqi64ZjI8oHoCJtW23lUUwlVtXOCor7nY8IE9qab6ew0l1MCRPepy7oOnnvH7C/9OpY= Received: by 10.35.41.12 with SMTP id t12mr4676233pyj; Thu, 10 Aug 2006 15:36:14 -0700 (PDT) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id k53sm1688695pyd.2006.08.10.15.36.12; Thu, 10 Aug 2006 15:36:14 -0700 (PDT) Message-ID: <44DBB4DB.6020605@gmail.com> Date: Fri, 11 Aug 2006 08:36:11 +1000 From: Chris User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Merlin Moncure CC: Sue Fitt , pgsql-performance@postgresql.org Subject: Re: setting up foreign keys References: <44DAE8CF.1030107@inf.ed.ac.uk> <44DAEB04.9050306@gmail.com> <44DAF6B7.1090800@inf.ed.ac.uk> <44DAF8B9.2080000@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.19 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/199 X-Sequence-Number: 20384 Merlin Moncure wrote: > On 8/10/06, Chris wrote: >> Sue Fitt wrote: >> > Thanks Chris and Chris, you've solved it. >> > >> > I had a gui open that connects to the database. It was doing nothing >> > (and not preventing me adding to or altering headwords_core via psql), >> > but having closed it the table is instantly created. Weird. >> > >> > BTW, referencing the same column twice is deliberate, it's a >> > cross-reference. >> >> The same column and the same table? >> >> Same column different table I could understand but not the same column & >> table ;) > > create table color(color text); > > create table person(eye_color text references color(color), hair_color > text references color(color)); lol. Good point :) *back to the hidey hole!* -- Postgresql & php tutorials http://www.designmagick.com/