Thread: Error message

Error message

From
hehe88hk@yahoo.com.hk (Eric)
Date:
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

Re: Error message

From
"scott.marlowe"
Date:
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?


Re: Error message

From
"Mattias Kregert"
Date:
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
>