Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group