Re: race condition in pgplsql call handler?

Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> writes:
> I'm looking into PG/PLSql code and following code in
> plpgsql_call_handler looks strange:

> /* Find or compile the function */
> func = plpgsql_compile(fcinfo, false);

> /* Mark the function as busy, so it can't be deleted from under
> us */
> func->use_count++;

> I don't have deep knowledge about this part of code. But what happen if
> in parallel execution "func" will be deleted between these two lines?

This is not a race condition because the backend is single-threaded.

(Hint: what it actually means by "function" is "the plpgsql function
cache entry I just found or built".)

regards, tom lane