From: Steve Midgley <public@misuse.org>
To: pgsql-sql@postgresql.org
Subject: Re: Usage of UUID with 8.3 (Windows)
Date: Tue, 12 Feb 2008 10:11:39 -0800
Message-ID: <20080212181530.3DD162E0278@postgresql.org> (raw)
In-Reply-To: <20080212172037.DEA542C9C87@maia-2.hub.org>
References: <20080212172037.DEA542C9C87@maia-2.hub.org>
At 09:20 AM 2/12/2008, pgsql-sql-owner@postgresql.org wrote:
>Date: Mon, 11 Feb 2008 11:56:33 -0500
>From: Tom Lane <tgl@sss.pgh.pa.us>
>To: ncode@gmx.com
>Cc: pgsql-sql@postgresql.org
>Subject: Re: Usage of UUID with 8.3 (Windows)
>Message-ID: <2916.1202748993@sss.pgh.pa.us>
>
>ncode@gmx.com writes:
> > Now, what do I have to do in order to generate a valid UUID (or the
> 5 different versions as implemented by the RFC) under Windows?
>
>Figure out how to build ossp-uuid on Windows ...
>
> regards, tom lane
You can review this thread too. MS provides native WinAPI tools and
language wrappers for this job:
http://answers.google.com/answers/threadview?id=553194
Here's the specific API call, which could possibly be wrapped inside PG
- however that raises the problem Tom notes about "boatloads of
platform specific code" -- I'd guess that a custom written stored
procedure is the way to go? Not sure how to make WinAPI calls from PG -
perhaps someone on list has experience or references for that:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rpc/rpc/uuidcreate.asp
HTH,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: public@misuse.org
Subject: Re: Usage of UUID with 8.3 (Windows)
In-Reply-To: <20080212181530.3DD162E0278@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox