Postgres Pro
Downloads
Home   >   mailing lists

Re: Clarification, please - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Clarification, please
Date
Msg-id 4CF62DC00200002500038023@gw.wicourts.gov
Whole thread Raw
In response to Clarification, please  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-performance
Tree view 
Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:

> How is it possible to insert the same value twice into a UNIQUE
> index?

You get multiple entries for the same value in a UNIQUE indexes all
the time in PostgreSQL.  Any non-HOT update of a table with a UNIQUE
index will cause that.  You just can't have duplicate entries with
overlapping visibility.

-Kevin

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Clarification, please
Next
From: Mladen Gogala
Date:
Subject: Re: SELECT INTO large FKyed table is slow