AW: [HACKERS] livetime of a variable defined in a c-procedure (fw d)

> "Victoria W." <wicki(at)terror(dot)de> writes:
> > CREATE FUNCTION add_rechnr(int4) RETURNS int4
> > AS '/usr/local/pgsql/lib/modules/funcs.so' LANGUAGE 'c';
>
> I don't think there is an "unload shared library" function in Postgres
> (it'd be hard or impossible to implement on some Unixes, anyway). So
> the only way to stop referencing a shared library once it's been opened
> is to terminate the backend process.
>
In my experience you can do the psql command:

load '/usr/local/pgsql/lib/modules/funcs.so';

after you changed the lib to load the new library into the backend.
Unfortunately I think you will lose the last value in "rechnr".

Andreas