Brendan Duddridge <brendan@xxxxxxxxxxxxxx> 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
