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 543C59FA42B for ; Wed, 21 Jun 2006 11:30:44 -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 99349-04 for ; Wed, 21 Jun 2006 11:30:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.204]) by postgresql.org (Postfix) with ESMTP id 2EDAC9FA501 for ; Wed, 21 Jun 2006 11:30:31 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s13so128223wxc for ; Wed, 21 Jun 2006 07:30:30 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=SDJHRburFLbLv60xQdIQ+lGCh0TmkuZU7YxHImxUsq6IyQreIPlFCeISoi3u322xEsU87YUZyaWOQvd6SeJLO1/2Zj9rwapS5jqz4fWSHHegU/7LC6LwVrkpW/nCGXhMYlPD+k0GSZ7TlECcj0Zo1RPg/a6IBw9CbklYDIXs1Wo= Received: by 10.70.26.10 with SMTP id 10mr1226007wxz; Wed, 21 Jun 2006 07:30:30 -0700 (PDT) Received: by 10.70.66.15 with HTTP; Wed, 21 Jun 2006 07:30:30 -0700 (PDT) Message-ID: Date: Wed, 21 Jun 2006 09:30:30 -0500 From: "Aaron Bono" To: ow Subject: Re: Unique constraint and index-combination feature in 8.1 Cc: pgsql-admin@postgresql.org In-Reply-To: <20060620104037.61116.qmail@web53911.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1429_9649975.1150900230446" References: <20060620104037.61116.qmail@web53911.mail.yahoo.com> X-Google-Sender-Auth: 38150cd135542e18 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/172 X-Sequence-Number: 22134 ------=_Part_1429_9649975.1150900230446 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Are you saying you want to create a unique constraint across the indexes of 2 or more columns rather than across the columns themselves? -Aaron On 6/20/06, ow wrote: > > > 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 > > ------=_Part_1429_9649975.1150900230446 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Are you saying you want to create a unique constraint across the indexes of 2 or more columns rather than across the columns themselves?

-Aaron

On 6/20/06, ow <oneway_111@yahoo.com> wrote:

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

------=_Part_1429_9649975.1150900230446--