On 07-May-99 abdelkrim wrote:
> CREATE FUNCTION complex_in(opaque)
> RETURNS complex
> AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so'
> LANGUAGE 'c';
> NOTICE: ProcedureCreate: type 'complex' is not yet defined
> NOTICE: ProcedureCreate: type 'complex' is not yet defined
> CREATE
Hmmm. Looks like the 'complex' type needs to be defined first.
I used a different example as a basis for adding types and functions,
it returned 'opaque' rather than a new type.
> CREATE FUNCTION complex_out(opaque)
> RETURNS opaque
> AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so'
> LANGUAGE 'c';
> CREATE
>
>
> CREATE TYPE complex (
> internallength = 16,
> input = complex_in,
> output = complex_out
> );
> CREATE
Have you tried putting this CREATE TYPE statement before the
first CREATE FUNCTION statement?
> CREATE TABLE test_complex (
> a complex,
> b complex
> );
> CREATE
>
>
> INSERT INTO test_complex VALUES ('(1.0, 2.5)', '(4.2, 3.55 )');
> assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file
> "/usr/src/libexec/rtld-elf/map_object.c", line 118
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally before or while
> processing the request.
> We have lost the connection to the backend, so further processing is
> impossible. Terminating.
>
>
>
> in the root console:
>
> assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file
> "/usr/src/libexec/rtld-elf/map_object.c", line 118
>
----------------------------------
Date: 10-May-99 Time: 11:01:42
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
----------------------------------