Arthur Chan <achan@comprehend.com> writes: > 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 > ...
I hope you are not offended if I ask the obvious question, but could it be a permissions problem? The lib exists, but are the user or group such that the PostgreSQL account can access it?