Postgres Pro
Downloads
Home   >   mailing lists

writing custom data type - Mailing list pgsql-novice

From Arthur Chan
Subject writing custom data type
Date
Msg-id CAAP2MxJ64q1Us3pTGQOA1016tO9pyow07xEMsPaZNmeiJm1WOQ@mail.gmail.com
Whole thread Raw
Responses Re: writing custom data type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
Hey Guys,

I've been having trouble writing my own custom datatype for PG. when I do my `CREATE FUNCTION` call, it fails with:

resultsets=# CREATE FUNCTION fuzzytime_in(cstring)
       RETURNS fuzzytime
       AS 'fuzzytimetype'                
       LANGUAGE C IMMUTABLE STRICT;
NOTICE:  return type fuzzytime is only a shell
ERROR:  could not find function "fuzzytime_in" in file "/usr/lib/postgresql/9.1/lib/fuzzytimetype.so"

--

now I checked my shared lib, and surely enough, it's there

$ objdump -t /usr/lib/postgresql/9.1/lib/fuzzytimetype.so
...
00000000000018b0 g     F .text 0000000000000070              fuzzytime_in
...

--

So what gives? The code has PG_MODULE_MAGIC, and I'm calling PG_FUNCTION_INFO_V1(fuzzytime_in);

I'd really appreciate any help with this.

Cheers,
Arthur Chan

pgsql-novice by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Installation 8.4 > 9.1
Next
From: Tom Lane
Date:
Subject: Re: writing custom data type