Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 207582E174F for ; Tue, 11 Mar 2008 17:32:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42119-01-7 for ; Tue, 11 Mar 2008 17:31:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.245]) by postgresql.org (Postfix) with ESMTP id 547C92E2D6F for ; Tue, 11 Mar 2008 17:31:49 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so616908ana.33 for ; Tue, 11 Mar 2008 13:31:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=N2VECaj8SH6Xgt4FusOjc1I9pwGPox3k43V6rZJWYXY=; b=HYpsVKfIHFOmzO0v7hxrbAPNo6Y/g9TmwSvp+eorXXmTLW+axqfOG3L8NPwzsjlHXo6herzS0WjePxPBn9CvgmF9ZgXJDm4HWXWXTBqZQd3IWQWUSVLUOIBoZFQx8B5GnuorImDepKvD4tNcLFholBRb293RMC2c/Yit8KXYMJk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cJFrOg+VLsu7wIaRpkvpv4yXbgjVYkJNNBqLz+s8c0M1lI8eDDCzI5nA3D21PrOcTiap0PGNA3WgZR51kkRg1FZ7WRRcdsXd76KOG6koBK7/uLKetB7o1GLcz3H7uMyMxd0WO6HAXineUMP2Qfkzw+Qy63SvpFclTHl3rUy02Q4= Received: by 10.100.119.17 with SMTP id r17mr14119971anc.42.1205267508152; Tue, 11 Mar 2008 13:31:48 -0700 (PDT) Received: by 10.100.122.9 with HTTP; Tue, 11 Mar 2008 13:31:48 -0700 (PDT) Message-ID: Date: Tue, 11 Mar 2008 15:31:48 -0500 From: "=?UTF-8?Q?Rodrigo_E._De_Le=C3=B3n_Plicet?=" To: pgsql-sql@postgresql.org Subject: Re: Composite UNIQUE across two tables? In-Reply-To: <5d0f60990803111203m18345c5ata6f4d407867ed60d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47D100E0.A3DD.0030.0@indicator.be> <20080307083421.26A9D700009D@mwinf2f21.orange.fr> <47D110C0.A3DD.0030.0@indicator.be> <5d0f60990803111203m18345c5ata6f4d407867ed60d@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/54 X-Sequence-Number: 30382 On Tue, Mar 11, 2008 at 2:03 PM, Dirk Jagdmann wrote: > For my tests, I have modified your posted schema a bit, to > unify all column names to "name". OT and IMHO, this is not good practice. Column names should be unique and descriptive throughout the entire schema.