Thread: BUG #1207: retrieve error

The following bug has been logged online:

Bug reference:      1207
Logged by:          SWU

Email address:      rojaine2003@yahoo.com

PostgreSQL version: 7.3.3

Operating system:   RedHat 7.0

Description:        retrieve error

Details:

Just recently I've met this error while retrieving a almost 15 thousand rows
of records and I'm unable to find a workaround on this. If any body out
there could help me with these error. Please share me with your knowledge.

Here's the following error:

A database error has occured.

Database error code: 7

Database error message:
Select error: SQLSTATE = HY000
ERROR: ItsWriteBlock: failed to write block 603 of
temporary file Perhaps out of disk space?

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Just recently I've met this error while retrieving a almost 15 thousand rows
> of records and I'm unable to find a workaround on this.

> ERROR: ItsWriteBlock: failed to write block 603 of
> temporary file Perhaps out of disk space?

You've run out of disk space.

            regards, tom lane