On Wed, 9 Feb 2000, Bryan White wrote:
> If I use CREATE FUNCTION for a C function in a .so file and then use the
> function and then change and recompile the function, what steps are needed
> to see the change?
>
> As I see it the options are:
> A: do nothing, the function is reloaded on every invocation.
> B: Reopen the connection to the backend
> C: Restart the postmaster
>
> I suspect B is correct but I would like to hear someone confirm it.
'B' is right - the postgreSQL not has any persisten cache for this, and
if you restart connection a backend reload this information again.
Or you can drop/(re)create a function, it is total safe solution.
Karel