Re: Error message

This is in Tcl, right?

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

/Mattias

----- Original Message -----
From: "Eric" <hehe88hk(at)yahoo(dot)com(dot)hk>
To: <pgsql-general(at)postgresql(dot)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
>