Re: uuid on windows

From: Richard Huxton <dev(at)archonet(dot)com>
To: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: uuid on windows
Date: 2008-11-14 10:39:42
Message-ID: 491D556E.2000009@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2008-11-14 10:55:40 Re: trapping a NULL querystring error
Previous Message Gerardo Herzig 2008-11-14 10:29:32 trapping a NULL querystring error