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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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.


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


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-2017 The PostgreSQL Global Development Group