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 2ED529FA5F0 for ; Tue, 20 Jun 2006 17:34:21 -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 10064-06 for ; Tue, 20 Jun 2006 17:34:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id C5D499F9998 for ; Tue, 20 Jun 2006 17:34:07 -0300 (ADT) Received: (qmail 24075 invoked by uid 500); 20 Jun 2006 20:37:57 -0000 Date: Tue, 20 Jun 2006 15:37:57 -0500 From: Bruno Wolff III To: ow Cc: pgsql-admin@postgresql.org Subject: Re: Unique constraint and index-combination feature in 8.1 Message-ID: <20060620203757.GC21987@wolff.to> Mail-Followup-To: Bruno Wolff III , ow , pgsql-admin@postgresql.org References: <20060620104037.61116.qmail@web53911.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060620104037.61116.qmail@web53911.mail.yahoo.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/164 X-Sequence-Number: 22126 On Tue, Jun 20, 2006 at 03:40:37 -0700, 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. I am not completely sure what you are asking. But if you want a unique constraint over multiple columns you can specify a unique table constraint using multiple columns when you create a table. If you are looking for something else, it might help to give a bit more description about what you are looking for.