Postgres Pro
Downloads
Home   >   mailing lists

Difference between UNIQUE constraint vs index - Mailing list pgsql-general

From John Jawed
Subject Difference between UNIQUE constraint vs index
Date
Msg-id a9eb35850702271643g1d07897eh21f6f47013718672@mail.gmail.com
Whole thread Raw
Responses Re: Difference between UNIQUE constraint vs index  ("Jim C. Nasby" <jim@nasby.net>)
Re: Difference between UNIQUE constraint vs index  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: How often do I need to reindex tables?
Next
From: Joseph S
Date:
Subject: Re: Slony subscription problem