Archive for the 'reindex' Category

[RUS] Dublicates on Unique Indexes / PostgreSQL Forum on SQL.RU | Появились дубли на уникальном индексе / PostgreSQL : Форум на SQL.RU

Thursday, April 1st, 2010

horror story about duplicate records in a table with UNIQUE index. The guy buid a pg himself (w/out knowing much about it), at some point pg included a patch that changed string sorting order, and that led to duplicate records. / you had to do REINDE…