RE: [INTERFACES] error insert

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
----------------------------------