"Hector Miranda" <[EMAIL PROTECTED]> writes:
> I'm working with Posgresql 7.0.3 on Red Hat linux 6.2. When I make the
> following query "select * from mytable" (2000000 rows),
You're running out of application memory for the query result. (libpq
doesn't recover from that too gracefully, unfortunately.) Consider
using a cursor to fetch the data in more manageable chunks.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
