Re: uuid on windows - Mailing list pgsql-sql

Sabin Coanda wrote:
> Hi there,
> 
> I installed Postgres "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" 
> on Windows OS, and I tried to check some uuid functions, for instance:
>         SELECT uuid_generate_v1();
> 
> But I found the following error message:
>     ERROR:  function uuid_generate_v1() does not exist

You'll want the uuid-ossp module:

http://www.postgresql.org/docs/8.3/static/datatype-uuid.html
http://www.postgresql.org/docs/8.3/static/uuid-ossp.html

I *think* it's one of the optional modules with recent installers, but I
don't run Windows routinely, so you'll have to check.

--  Richard Huxton Archonet Ltd