"Claudio Lapidus" <clapidus(at)hotmail(dot)com> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>> Does a REINDEX of the table fix it?
> Hmm, I'm looking at the documentation and it says that REINDEX acquires an
> exclusive lock on the table. Does this mean that during the reindex
> operation the table is unavailable for read/write by other processes?
Yes. At the moment, I am just asking this as a means of helping to
pinpoint where the problem is.
regards, tom lane