I'm already using a cursor via ODBC. > 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 5: don't forget to increase your free space map settings