Re: Unique Index vs. Unique Constraint - Mailing list pgsql-general

From Jan Wieck
Subject Re: Unique Index vs. Unique Constraint
Date
Msg-id 3F8AB283.8000308@Yahoo.com
Whole thread Raw
In response to Re: Unique Index vs. Unique Constraint  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
scott.marlowe wrote:

> On Fri, 10 Oct 2003, Thomas LeBlanc wrote:
>
>> Does a Unique Constraint build a unique index?
>>
>> What is the difference?
>
> None that I know of.

A different implementation of UNIQUE constraint might allow
deferrability, what our index solution does not ... yet.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Performance weirdness with/without vacuum analyze
Next
From: Harry Broomhall
Date:
Subject: Re: Performance weirdness with/without vacuum analyze