"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> how odd. Since reindex works by dropping the index then recreating it, is
> it possible that some process inserted duplicates in the split second
> there was no index?
No, because reindex holds exclusive lock on the table for the whole
process.
regards, tom lane