Re: Weird error updating table

Brendan Duddridge <brendan(at)clickspace(dot)com> writes:
> Next exception:SQL State:XX000 -- error code: 0 -- msg: ERROR:
> could not read from hash-join temporary file: Unknown error: 0

> Any one know what that could mean?

It seems to imply unexpected end-of-file while reading from a temp file
... unless the kernel forgot to set errno during some other failure.
What platform is this on, exactly?

Looking at the code, it looks like BufFileClose is sloppy about checking
for errors (such as out-of-disk-space) while flushing out the very last
block of a temp file. Is it possible that your query just barely ran
the machine out of disk space?

regards, tom lane