Sabin Coanda wrote:
> I run the following script and now it works:
>
> CREATE OR REPLACE FUNCTION uuid_generate_v1()
> RETURNS uuid
> AS '$libdir/uuid-ossp', 'uuid_generate_v1'
> VOLATILE STRICT LANGUAGE C;
>
> Similar for all the other defined uuid functions.
There should be a uuid-ossp.sql file with all those definitions in. Also
an "uninstall" version of the file too.
> Unfortunatelly I experienced the same problem on linux version 8.3.5. after
> I installed the package. But there the same script doesn't work, and logs
> that the file is not found.
The uuid-ossp.so file? Is it in the right directory? Is it readable by
the postgres user?
-- Richard Huxton Archonet Ltd