From: | Craig Orsinger <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil> |
---|---|
To: | abdelkrim <haj(at)idianet(dot)net> |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | RE: [INTERFACES] error insert |
Date: | 1999-05-10 18:32:59 |
Message-ID: | XFMail.990510113259.orsingerc@epg-gw1.lewis.army.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)epg(dot)lewis(dot)army(dot)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
----------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Orsinger | 1999-05-10 18:58:25 | RE: [INTERFACES] error insert |
Previous Message | Thomas Lockhart | 1999-05-10 18:04:06 | Re: [INTERFACES] Java and PGSQL date question |