Difference between UNIQUE constraint vs index

From: "John Jawed" <johnjawed(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Difference between UNIQUE constraint vs index
Date: 2007-02-28 00:43:51
Message-ID: a9eb35850702271643g1d07897eh21f6f47013718672@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any difference as far as when the "uniqueness" of values is
checked in DML between a unique index vs a unique constraint? Or is
the only difference syntax between unique indices and constraints in
PostgreSQL?

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph S 2007-02-28 00:44:45 Re: Slony subscription problem
Previous Message Ron Johnson 2007-02-27 23:57:26 Re: How often do I need to reindex tables?