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 D912A9FB2B2 for ; Thu, 10 Aug 2006 06:13:38 -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 59272-09 for ; Thu, 10 Aug 2006 06:13:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id 7A3949FB2AA for ; Thu, 10 Aug 2006 06:13:35 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so822263pyd for ; Thu, 10 Aug 2006 02:13:34 -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=ZMs2zoQUu/NpyYWpVR0BDf7QsQfaX6d3KlNPM2RZKe+ZV6QqwOicA8Lefv5TkFGnbjqQeGwAzrF1TgHzjJNVJfbkVIjwa7Ot7KbsG/MBB3xHrsECMkUsxMUI8kGKmejkAQrp52VVG8+xHs2KJEDX09JZaBKxdYlQq/oPwyx/m6k= Received: by 10.35.99.5 with SMTP id b5mr3480550pym; Thu, 10 Aug 2006 02:13:33 -0700 (PDT) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 17sm1245003nzo.2006.08.10.02.13.31; Thu, 10 Aug 2006 02:13:33 -0700 (PDT) Message-ID: <44DAF8B9.2080000@gmail.com> Date: Thu, 10 Aug 2006 19:13:29 +1000 From: Chris User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Sue Fitt CC: 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> In-Reply-To: <44DAF6B7.1090800@inf.ed.ac.uk> 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.189 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/179 X-Sequence-Number: 20364 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 ;) I'm sure there's a reason for it though :) -- Postgresql & php tutorials http://www.designmagick.com/