Re: Problems with PostGreSQL and Windows 2003 - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Problems with PostGreSQL and Windows 2003
Date
Msg-id 20071125162121.GC32482@svana.org
Whole thread Raw
In response to Re: Problems with PostGreSQL and Windows 2003  (claudia.amorim@pcinformatica.com.br)
Responses Re: Problems with PostGreSQL and Windows 2003  (claudia.amorim@pcinformatica.com.br)
List pgsql-general
On Sun, Nov 25, 2007 at 10:38:31AM -0200, claudia.amorim@pcinformatica.com.br wrote:
> Hello,
>
> I changeded shared buffers to 256 MB. But I still receiving the error message.
> So I changed to 128 MB, and I received the error again.
> I'm using a cursor via ODBC.

Are you using a cursor, because it certainly doesn't look like you're
using a cursor, just a plain select. Which probably means youre client
side is running out of memory.

So, check you're using a cursor. Or just limit the output to however
many rows you actually want.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: claudia.amorim@pcinformatica.com.br
Date:
Subject: Re: Problems with PostGreSQL and Windows 2003
Next
From: claudia.amorim@pcinformatica.com.br
Date:
Subject: Re: Problems with PostGreSQL and Windows 2003