Re: race condition in pgplsql call handler?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: race condition in pgplsql call handler?
Date: 2007-05-11 13:51:25
Message-ID: 18626.1178891485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2007-05-11 14:31:09 Re: Logging checkpoints and other slowdown causes
Previous Message Zdenek Kotala 2007-05-11 13:39:50 Re: race condition in pgplsql call handler?