John P. Looney writes:
> I'm trying to write a few functions in C for postgres. But, when I change
> some code, I'm never sure that it'll be flushed when I do a;
>
> DROP FUNCTION test();
> CREATE FUNCTION test() RETURNS text AS '/var/lib/pgsql/functions/test.so' LANGUAGE 'c';
>
> Is there a way to make sure ? Even restarting postgres doesn't always
> work (or else my makefiles are broken...)
While in general this is platform-dependent, recreating the function at
least *could* work in many cases. Restarting the server should work in
any case. So possibly your build process needs adjustment.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter