Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique constraint and index-combination feature in 8.1 - Mailing list pgsql-admin

From Aaron Bono
Subject Re: Unique constraint and index-combination feature in 8.1
Date
Msg-id bf05e51c0606210730v90e815ar803d9d4cc44f5978@mail.gmail.com
Whole thread Raw
In response to Unique constraint and index-combination feature in 8.1  (ow <oneway_111@yahoo.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: "Nicola Mauri"
Date:
Subject: Dump size bigger than pgdata size?
Next
From: "Aaron Bono"
Date:
Subject: Re: Dump size bigger than pgdata size?