Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7E5619FBA16 for ; Wed, 28 Mar 2007 10:28:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 19724-02 for ; Wed, 28 Mar 2007 10:28:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.231]) by postgresql.org (Postfix) with ESMTP id 035E79FBA20 for ; Wed, 28 Mar 2007 10:28:21 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id r28so2277114nza for ; Wed, 28 Mar 2007 06:28:20 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=M9hCcjCSKrrvFbmbM/9KjgN9QHP3LUrkIPqIfmPT8lXR47J8UR78KLoBY1w1daTNQ9WJyqpetfi68m01M1UuXf/wHzHW+GkdmnBgxqFt3psGhNruemICcWuvdvscPHwfg44+VJp8Y95sf8hTsTn/x7tK4AjS60a8RCw/lEHRTiY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=uAS2skxr4xizX+CzCp3dbBC8a5gnKfjG+fSBGuftun4eZlIEd/drO18NNhk83nzeS3RI2pPXnPgFhyy8NLf5Kw7U4TAZ6k5CxJskjwfhVooGDEKyiQWIS6+yzqwfIbORn9N20LdZhzqS1SX8RsrDHcpDgAG3r6it4qlhdwq5u20= Received: by 10.114.201.1 with SMTP id y1mr3710128waf.1175088499794; Wed, 28 Mar 2007 06:28:19 -0700 (PDT) Received: by 10.114.47.8 with HTTP; Wed, 28 Mar 2007 06:28:19 -0700 (PDT) Message-ID: <4f4c2a010703280628q5cbfd9d9xd511230f8545d1c8@mail.gmail.com> Date: Wed, 28 Mar 2007 09:28:19 -0400 From: "Jon Horsman" To: "Peter Eisentraut" Subject: Re: Foreign Unique Constraint Cc: pgsql-sql@postgresql.org, "Phillip Smith" In-Reply-To: <200703281108.08697.peter_e@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <002501c770bd$a42f94a0$9b0014ac@wbaus090> <200703281108.08697.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/329 X-Sequence-Number: 27967 > Subqueries are not allowed in check constraints. I hadn't tried this yet but i'm sure i would have figured this out quickly then =) Thanks, Jon