On Oct 2, 2009, at 8:49 AM, Tom Lane wrote:
> The ideal is that backends will start using the new function
> implementation on the next call after the REPLACE commits (but any
> evaluations already in progress must of course continue with the text
> they have). We have been gradually getting closer to that ideal over
> the years, although I think there are still cases where it will take a
> little longer --- for instance if a SQL function gets inlined I think
> the inlined code will persist for the duration of the query's
> execution.
> I don't believe there are still any cases where you actually have to
> reconnect to get it to notice the update.
>
> (At least this is true for plpgsql --- not sure if all the other PLs
> are equally up to speed.)
Ah, good to know. Perhaps an audit is in order…
Best,
David