Re: LOADing functions

Andrew Becker <acbecker(at)gmail(dot)com> writes:
> Hi - I seem to be unable to reLOAD a shared library within the session
> that I LOADed it.

Nope, you can't, there's no such functionality.

> Hints as to what is going wrong here? I would certainly expect to be
> able to re-load a shared library while debugging my UDF.

That would require being able to unload it, which is an operation fraught
with hazards. We used to allow that, but gave it up after observing that
practically every extant extension could be made to crash on unload.
There is for instance no safe way to get out of a function hook --- the
code pattern you may have seen of restoring the prior value is wrong and
unsafe, because it doesn't account for some other extension having plugged
into the hook after you. You'd leave that other extension kneecapped,
with some of its hook callbacks disabled but others perhaps not.

regards, tom lane