As documented here:
http://www.postgresql.org/docs/9.0/interactive/uuid-ossp.html
Rather than assuming the host operating system has an implementation of UUID, Postgres depends on the presence of a
specificimplementation of UUID generation & handling. This open-source implementation is called "OSSP uuid", found
here:
http://www.ossp.org/pkg/lib/uuid/
My guess:
You compiled the code necessary for Postgres to reach out to this UUID implementation. But you are missing the actual
UUIDimplementation.
The OneClick installer from EnterpriseDB.com placed this on my Mac, which I assume is the UUID implementation:
/Library/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
In addition I found what I assume is the code that enables Postgres to reach out and call that implementation.
/Library/PostgreSQL/9.0/lib/libuuid.dylib
/Library/PostgreSQL/9.0/lib/libuuid.la
Lastly I found this SQL script which I ran to enable the already-complied code:
/Library/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql
I'm no expert, but I hope that helps.
--Basil Bourque
> I have linux server. Package uuid installed
>
> I build and install postgresql from source with --with-ossp-uuid flag.
>
> After installation I try to execute:
>
> =======
> create or replace function
> uuid_generate_v1()
>
> returns
> uuid
>
> as '$libdir/uuid-ossp', 'uuid_generate_v1'
>
> volatile strict language C
>
> =======
>
> and got error
>
> "could not load libraty /usr/lib/postgresql/uuid-ossp.so": /usr/lib/postgresql/uuid-ossp.so: undefined symbol:
uuid_error"
>
> How I can fix it?