Received: from localhost (unknown [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id B008B2E0099
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 25 Nov 2007 08:42:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 78355-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 25 Nov 2007 08:42:00 -0400 (AST)
Received: from pcinformatica.com.br (ns1.pcinformatica.com.br [201.24.152.3])
	by postgresql.org (Postfix) with ESMTP id 3D0932E00AB
	for <pgsql-performance@postgresql.org>;
	Sun, 25 Nov 2007 08:42:04 -0400 (AST)
Received: (qmail 18653 invoked by uid 88); 25 Nov 2007 12:42:02 -0000
Received: from 127.0.0.1 by smart (envelope-from
	<claudia.amorim@pcinformatica.com.br>,
	uid 89) with qmail-scanner-1.25 (uvscan: v4.4.00/v4400.  
	Clear:RC:1(127.0.0.1):.
	Processed in 0.411216 secs); 25 Nov 2007 12:42:02 -0000
X-Qmail-Scanner-Mail-From: claudia.amorim@pcinformatica.com.br via smart
X-Qmail-Scanner: 1.25 (Clear:RC:1(127.0.0.1):. Processed in 0.411216 secs)
X-Qmail-Util: Version 0.6.3
Received: from unknown (HELO 201.24.152.6) (127.0.0.1)
	by 0 with SMTP; 25 Nov 2007 12:42:01 -0000
Received: from 189.5.149.224 (SquirrelMail authenticated user
	claudia.amorim@pcinformatica.com.br) by smart with HTTP;
	Sun, 25 Nov 2007 10:42:01 -0200 (BRST)
Message-ID: <62578.189.5.149.224.1195994521.squirrel@smart>
In-Reply-To: <dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com>
References: <50326.189.5.149.224.1195860047.squirrel@smart>
	<4747E684.2000509@enterprisedb.com>
	<50662.189.5.149.224.1195905625.squirrel@smart>
	<58995.189.5.149.224.1195966621.squirrel@smart>
	<dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com>
Date: Sun, 25 Nov 2007 10:42:01 -0200 (BRST)
Subject: Re: Problems with PostGreSQL and Windows 2003
From: claudia.amorim@pcinformatica.com.br
To: "Scott Marlowe" <scott.marlowe@gmail.com>
Cc: claudia.amorim@pcinformatica.com.br,
	"Heikki Linnakangas" <heikki@enterprisedb.com>,
	pgsql-performance@postgresql.org, claudiacomput@hotmail.com
User-Agent: SquirrelMail/1.4.8
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.766 tagged_above=0 required=5 tests=AWL=-1.116,
	BAYES_40=-0.185, RCVD_NUMERIC_HELO=2.067
X-Spam-Level: 
X-Archive-Number: 200711/288
X-Sequence-Number: 27703



I'm already using a cursor via ODBC.




> On Nov 24, 2007 10:57 PM,  <claudia.amorim@pcinformatica.com.br> 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
>