Thread: Error message

Hello.

After I have performed several queries by an external program on the
database, an error message appeared:
"hard limit on result handles reached is not a valid query result"

May I know how to solve the problem?
Thank you

On 3 Mar 2004, Eric wrote:

> Hello.
>
> After I have performed several queries by an external program on the
> database, an error message appeared:
> "hard limit on result handles reached is not a valid query result"
>
> May I know how to solve the problem?

Sounds like an application issue, not postgresql.  What language are you
using, and might you share some code?

This is in Tcl, right?

You are creating queries without clearing the result handles. Make sure you always clear the result handles after
gettingthe data. I noticed this problem too when I upgraded to latest version of Tcl, where the number of open handles
arelimited. When I found that bug and fixed it, my app suddenly stopped its bad habit of slowly eating up memory and
slowingdown... :) 


/Mattias

----- Original Message -----
From: "Eric" <hehe88hk@yahoo.com.hk>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, March 03, 2004 4:57 PM
Subject: [GENERAL] Error message


> Hello.
>
> After I have performed several queries by an external program on the
> database, an error message appeared:
> "hard limit on result handles reached is not a valid query result"
>
> May I know how to solve the problem?
> Thank you
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>