"Morris, Roy" <rmorris@internetsecure.com> writes:
> postgres=# CREATE FUNCTION
> postgres-# uuid_in(CSTRING) RETURNS uuid
> postgres-# STRICT
> postgres-# LANGUAGE C AS '/usr/lib/pgsql/uuid.so', 'pg_uuid_in';
> ERROR: could not access file "/usr/lib/pgsql/uuid.so": No such file or
> directory
Um ... why are you trying to do that? uuid_in is built in as of 8.4.
It looks to me like you are trying to force the thing to take
definitions from an old version of contrib/uuid, and that's not gonna
work.
If you've got these definitions in an old dump file, just ignore the
errors on load.
regards, tom lane