problem with CREATE FUNCTION

From: Richard Harvey Chapman <hchapman(at)3gfp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with CREATE FUNCTION
Date: 2000-09-21 21:09:07
Message-ID: Pine.LNX.4.10.10009201650400.2124-100000@smirk.3gfp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Harvey Chapman 2000-09-21 21:17:34 Re: problem with CREATE FUNCTION
Previous Message Andrew McMillan 2000-09-21 20:51:03 Re: import CVS file