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