On Nov 24, 2007 10:57 PM, <claudia.amorim@xxxxxxxxxxxxxxxxxxxx> wrote: > Hello, > > I forgot to say that I changed work_mem to 16 MB but I didn't have sucess. > I received the same > error message. The error message you're getting is from your client because it's getting too big of a result set back at once. Try using a cursor ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly