Unique constraint and index-combination feature in 8.1

From: ow <oneway_111(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Unique constraint and index-combination feature in 8.1
Date: 2006-06-20 10:40:37
Message-ID: 20060620104037.61116.qmail@web53911.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-06-20 14:11:51 Re: DocBook 4.2 detecting at configure time
Previous Message Stefan.Schmidt 2006-06-20 10:31:17 2,2gb of pg_xlog ??