Re: problem with CREATE FUNCTION

Update:

The problem, I think, is with psql.  I never tried quitting and restarting
psql, but apparently that's required everytime you change a shared object
file.

"Urge to kill rising..."

R.

On Thu, 21 Sep 2000, Richard Harvey Chapman wrote:

> I'm trying to create a function for dynamically calling plsql functions,
> and I can't debug it due to a problem with postgres.
>
> My c function compiles fine.
>
> I execute:
>
> CREATE FUNCTION myfunc (text)
> RETURNS text
> AS '/myfuncs/myfunc.so'
> LANGUAGE 'C';
>
> and then a simple run of the function:
>
> SELECT myfunc('some text');
>
> It works.
>
> Now, change something in the function, recompile, and postgres continues
> to use the old code. I've tried dropping the function, and recreating it.
> I've tried renaming the shared object file.  It doesn't work.  Am I
> missing something?
>
> Although, all of this wouldn't be necessary if someone would tell me how
> to dynamically call functions in postgres (see my previous post regarding
> "dynamic sql..."
>
> Thanks,
>
> R.
>
>