Re: LOADing functions

On 10/31/2014 03:00 PM, Andrew Becker wrote:
> Hi - I seem to be unable to reLOAD a shared library within the session
> that I LOADed it. I am developing a UDF and my debugging changes do not
> appear to take until I quit psql and restart. The following code
> sequence demonstrates the issue
>
> |kbmod=# CREATE OR REPLACE FUNCTION hello(TEXT) RETURNS TEXT
> AS '/Users/acbecker/src/github/kbmod/src/hello.so', 'hello'
> LANGUAGE C STRICT;
>
> ||kbmod=# SELECT hello( name ) FROM test;
> hello
> ----------------
> Hello4, Xavier
> Hello4, Yari
> Hello4, Zack
> (3 rows)
>
>
> ### HERE I MODIFY hello.c TO TYPE "Hello5" AND REBUILD hello.so
> |
>
> |### DROPPING AND RECREATING THE FUNCTION DOES NOT WORK
>
> kbmod=# DROP FUNCTION hello(TEXT);
>
> kbmod=# CREATE OR REPLACE FUNCTION hello(TEXT) RETURNS TEXT
> AS '/Users/acbecker/src/github/kbmod/src/hello.so', 'hello'
> LANGUAGE C STRICT;
>
> kbmod=# SELECT hello( name ) FROM test;
> hello
> ---------------
> Hello4, Xavier
> Hello4, Yari
> Hello4, Zack
>
>
> ### RELOADING THE SHARED LIBRARY ALSO DOES NOT HELP
> |
>
> |kbmod=# LOAD '/Users/acbecker/src/github/kbmod/src/hello.so';
> LOAD
>
> kbmod=# SELECT hello( name ) FROM test;
> hello
> ----------------
> Hello4, Xavier
> Hello4, Yari
> Hello4, Zack
> (3 rows)
> |
> ### HOWEVER, AFTER QUITTING AND RESTARTING, THE CHANGE TAKES
>
> |kbmod=# \q
>
> prompt>:/opt/local/lib/postgresql93/bin/psql -U postgres -d kbmod
>
> psql (9.3.5)
> Type "help" for help.
>
> kbmod=# SELECT hello( name ) FROM test;
> hello
> ----------------
> Hello5, Xavier
> Hello5, Yari
> Hello5, Zack
> (3 rows)|
>
>
>
> 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.

The docs would say otherwise:

http://www.postgresql.org/docs/9.3/interactive/sql-load.html

This command loads a shared library file into the PostgreSQL server's
address space. If the file has been loaded already, the command does
nothing.

>
> Thanks,
> Andy
>
> psql 9.3.5 from Macports
> on OS X 10.10

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com