Re: uuid on windows - Mailing list pgsql-sql

From Richard Huxton
Subject Re: uuid on windows
Date
Msg-id 491D556E.2000009@archonet.com
Whole thread Raw
In response to Re: uuid on windows  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: uuid on windows
Next
From: Gerardo Herzig
Date:
Subject: trapping a NULL querystring error