From: | Richard Harvey Chapman <hchapman(at)3gfp(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with CREATE FUNCTION |
Date: | 2000-09-21 21:17:34 |
Message-ID: | Pine.LNX.4.10.10009211416050.568-100000@smirk.3gfp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 2000-09-21 21:35:11 | Re: Application data refreshing |
Previous Message | Richard Harvey Chapman | 2000-09-21 21:09:07 | problem with CREATE FUNCTION |