Michael Fuhr wrote:
On Tue, Jan 17, 2006 at 03:37:14PM -0500, David Rysdam wrote:
I have a Tcl function that does this:
1) create prepared statement for binary insertion via pg_exec (and
releases the result handle)
2) run statement with binary data via pg_exec_prepared (and releases the
result handle)
3) deallocate statement via pg_exec (and releases the result handle)
When I try to run this function a couple hundred times, I get "had limit
on result handles reached" after 128 successes. It seems something is
not being released.
Can you post a simple test case? I can provoke "hard limit on
result handles reached" by not clearing results, but so far I haven't
seen that error if I do clear all results.
Sorry, I was wrong. I had a connection leak that was hidden because my
accounting procedure and the actual code made different assumptions.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
