Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 27 Feb 2007 18:43:51 -0600
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
- Follow-Ups:
- Re: Difference between UNIQUE constraint vs index
- From: Joshua D. Drake
- Re: Difference between UNIQUE constraint vs index
- From: Jim C. Nasby
- Re: Difference between UNIQUE constraint vs index
- Prev by Date: Re: How often do I need to reindex tables?
- Next by Date: Re: Slony subscription problem
- Previous by thread: Recovering from a corrupt database
- Next by thread: Re: Difference between UNIQUE constraint vs index
- Indexes: