From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | claudia(dot)amorim(at)pcinformatica(dot)com(dot)br |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems with PostGreSQL and Windows 2003 |
Date: | 2007-11-25 16:21:21 |
Message-ID: | 20071125162121.GC32482@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Nov 25, 2007 at 10:38:31AM -0200, claudia(dot)amorim(at)pcinformatica(dot)com(dot)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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
From | Date | Subject | |
---|---|---|---|
Next Message | claudia.amorim | 2007-11-25 16:26:17 | Re: Problems with PostGreSQL and Windows 2003 |
Previous Message | Andrus | 2007-11-25 13:39:59 | Why LIMIT and OFFSET are commutative |