View Single Post

   
  #4 (permalink)  
Old 04-12-2008, 09:39 AM
Tom Lane
 
Posts: n/a
Default Re: race condition in pgplsql call handler?

Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> Tom Lane wrote:
>> This is not a race condition because the backend is single-threaded.


> I see. Each backend has own function cache and use_count is for handle
> recursion usage. Are my assumption correct?


Right. Once a function cache entry is set up, it exists unchanged until
no longer in use, no matter what happens to the underlying pg_proc row.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote