| 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: | Whole Thread | Raw Message | 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 |