Mladen Gogala <mladen.gogala@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance