Re: writing & flushing C extensions

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(at)gmx(dot)net http://funkturm.homeip.net/~peter