The following bug has been logged online:

Bug reference: 1207
Logged by: SWU

Email address: rojaine2003 (AT) yahoo (DOT) 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?



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
You've run out of disk space.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)