X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 014149FA3CD for ; Tue, 20 Jun 2006 07:40:43 -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 01228-09 for ; Tue, 20 Jun 2006 07:40:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web53911.mail.yahoo.com (web53911.mail.yahoo.com [206.190.38.160]) by postgresql.org (Postfix) with SMTP id B62339FA219 for ; Tue, 20 Jun 2006 07:40:39 -0300 (ADT) Received: (qmail 61118 invoked by uid 60001); 20 Jun 2006 10:40:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=YJzFPWXWD02KVcQe8Teu3OkAH3e0FxlV//dlv830EPPJYgTaSk6rFXbMWq3O7DbZapfKqlTDv4XNX09DSsrig5TZrFR6UTsvX3RnvzqzLr4A6fxExigsFYZyfaV3ZUi1WveCfsX+5e1+fKjlJdHlz+nnxEQvaERyptjivc04y4A= ; Message-ID: <20060620104037.61116.qmail@web53911.mail.yahoo.com> Received: from [24.47.116.3] by web53911.mail.yahoo.com via HTTP; Tue, 20 Jun 2006 03:40:37 PDT Date: Tue, 20 Jun 2006 03:40:37 -0700 (PDT) From: ow Subject: Unique constraint and index-combination feature in 8.1 To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/155 X-Sequence-Number: 22117 Hi, Is it somehow possible to create a UNIQUE constraint that relies on non-unique ONE-column indexes and uses index-combination feature in 8.1 ? The alternative, which we use now, is to create a unique MULTI-column index on the respective coulumns. Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com