Thread: Hard limit on result handles reached ...

  "Error: hard limit on result handles reached is not a valid query result"

I received this message while running a loop that called an insert into a table.
It seem to happen sometime after the hundredth insert.

When I connected and disconnected to the database for each insert (I know,
overkill), I found I could run without incident.

Stack trace showed it had a problem with the tcl command "pg_result
$query -error".  I use this to show whether errors occurred during the run.

My question is, am I doing something fundamentally wrong or is there some
counter I need to reset?

Thanks,

Paul André
JNR Associates

Are you doing a "pg_result -clear" to release each pg_exec result
when you are done with it?  If not, you'll eventually run out of
memory...

            regards, tom lane

That's what I did not know....

Thanks,
Paul André
JNR Associates

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, June 26, 2001 10:28 AM
To: Paul Andre
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Hard limit on result handles reached ...


Are you doing a "pg_result -clear" to release each pg_exec result
when you are done with it?  If not, you'll eventually run out of
memory...

            regards, tom lane