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
>