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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers