Re: prepared statement results don't clear?

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.