Thread: Re: [INTERFACES] pb when creating user type

Re: [INTERFACES] pb when creating user type

From
"abdelkrim"
Date:
>        Is this a test? If so, I failed. I don't see where you create your
>'complex_in()' function. Is it in a part of a script you forgot to include
>in your original post?

complex_in(), complex_out() and complex_add() fonctions are defined in
complex.c

>
>        Anyway, if that's the entire script, add a "CREATE FUNCTION"
>statement for 'complex_in()' and it should work a lot better.
>


thanks for your help,
my operating system is FreeBSD 3.1
I use Postgresql-6.4.2

I tried :           gcc -g -c -fpic -o complex.o complex.c           ld -Bshareable -o complex.so complex.o
it is the same error.




Re: [INTERFACES] pb when creating user type

From
Craig Orsinger
Date:
On 04-May-99 abdelkrim wrote:
>  complex_in(), complex_out() and complex_add() fonctions are defined in
> complex.c
> 
>>
>>        Anyway, if that's the entire script, add a "CREATE FUNCTION"
>>statement for 'complex_in()' and it should work a lot better.
>>
       Actually, I was referring to your SQL script. I did not see a
"CREATE FUNCTION" statement for the 'complex_in()' function, only the
'complex_out()' function. You need to have one for each function in
your library ("complex.so").
       I'm doing similar things with PostgreSQL 6.4.2 on Linux and HPUX,
and both are working fine - so it is possible.

> 
> thanks for your help,
> my operating system is FreeBSD 3.1
> I use Postgresql-6.4.2
> 

----------------------------------
Date: 04-May-99  Time: 10:00:07

Craig Orsinger                  (email: <orsingerc@epg.lewis.army.mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------