Re: prepared statement results don't clear? - Mailing list pgsql-general

From David Rysdam
Subject Re: prepared statement results don't clear?
Date
Msg-id 43CE434D.4030100@ll.mit.edu
Whole thread Raw
In response to Re: prepared statement results don't clear?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Peerri (sent by Nabble.com)"
Date:
Subject: Image in postgresql 7.3
Next
From: Berend Tober
Date:
Subject: Re: Image in postgresql 7.3