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