PostgreSQL Enforces Uniqueness at Heap Level, Not in Index

PostgreSQL's unique indexes allow duplicate index entries because they append TID to the key, unlike Oracle. Uniqueness is verified by checking heap tuple visibility under MVCC, not by the index structure. This design accommodates multiple row versions but requires heap visits for uniqueness checks.