Re: Unique constraint and index-combination feature in 8.1

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Unique constraint and index-combination feature in 8.1
Date: 2006-06-21 14:30:30
Message-ID: bf05e51c0606210730v90e815ar803d9d4cc44f5978@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)yahoo(dot)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
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message alex.cotarlan 2006-06-21 14:37:32 Re: Dump size bigger than pgdata size?
Previous Message Nicola Mauri 2006-06-21 14:30:17 Dump size bigger than pgdata size?