Re: BUG #14598: Duplicate values found when reindexing unique index

John R Pierce <pierce(at)hogranch(dot)com> writes:
> However, running out of disk space in the disk volume holding pgdata is
> a catastrophic error, that can leave the database in an unknown state,
> depending on exactly what was allocating file space when it ran out.

It's not supposed to do that; the worst case ought to be a forced
database shutdown until you free up some space. (And that should
be an unusual case -- ideally, you just get a normal query failure
from an INSERT or UPDATE.) So there may in fact be a bug here,
if there were not any additional factors involved. But, as was said
upthread, 8.1.x is long out of support and nobody in the community
is likely to investigate bug reports against it for free.

If the OP is sufficiently desperate, he could probably hire one of
the various PG support companies to investigate, or at least help
him with data recovery.

regards, tom lane