Re: Clarification, please

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org >> \"pgsql-novice(at)postgresql(dot)org\"" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Clarification, please
Date: 2010-12-01 17:34:53
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com> writes:
> I agree with you. I was only wandering how was it done with a unique index.

Maybe the point you're missing is that PG unique indexes aren't unique
in the sense of it being physically impossible to represent duplicate
keys. The uniqueness property just means that there's a check that
throws error instead of allowing a live duplicate to be inserted.
(Dead duplicates are OK --- in particular, we have to allow multiple
nominal duplicates to support MVCC, since an update requires a new
physical table entry and hence a new index entry pointing at it, in
most cases.)

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Pushpendra Singh Thakur 2010-12-01 21:05:31 Hot standby
Previous Message Mladen Gogala 2010-12-01 17:28:17 Re: Clarification, please