Re: Creating server-side functions: one simple error

Tom Lane wrote:

> Ruslan A Dautkhanov <rusland@scn.ru> writes:
> > I have to create my own function in C lanuage, which
> > will use SPI. The problem that when I had done all things,
> > PostgreSQL says:
> >     isbs=# select pgf1test('123');
> >     ERROR:  Can't find function pgf1test in file /usr/local/pgsql/lib/pgf1test.so
>
> But it got past the CREATE FUNCTION command without complaint?  That's
> odd, because CREATE FUNCTION should make the same check.
>
> Does the behavior change if you start a fresh session?  If so, see
> the LOAD command, which you need to use (or start a fresh session)
> after any change of the shared library file.
>
>                         regards, tom lane

Yes, you right, I just must run LOAD - after LOAD had complete all works good. Thanks.
Btw, how I can convert TEXT field to a CString one? I had tried to use
  char *cnum = PG_GETARG_CSTRING(0)  instead of
  text tnum = PG_GETARG_NAME(0),   but it's not worked properly. Is any function
to convert text object to a null-terminated string??? Thanks again.


--
  best regards,
 Ruslan A Dautkhanov   rusland@scn.ru