Skip site navigation (1) Skip section navigation (2)

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 08:46:55
Message-ID: 491D3AFF.70502@archonet.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-sql by date

Next:From: Sabin CoandaDate: 2008-11-14 10:26:33
Subject: Re: uuid on windows
Previous:From: Sabin CoandaDate: 2008-11-14 07:38:01
Subject: uuid on windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group