Re: uuid on windows

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