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
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 |