From: | Steve Midgley <public(at)misuse(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Usage of UUID with 8.3 (Windows) |
Date: | 2008-02-12 18:11:39 |
Message-ID: | 20080212181530.3DD162E0278@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
At 09:20 AM 2/12/2008, pgsql-sql-owner(at)postgresql(dot)org wrote:
>Date: Mon, 11 Feb 2008 11:56:33 -0500
>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: ncode(at)gmx(dot)com
>Cc: pgsql-sql(at)postgresql(dot)org
>Subject: Re: Usage of UUID with 8.3 (Windows)
>Message-ID: <2916(dot)1202748993(at)sss(dot)pgh(dot)pa(dot)us>
>
>ncode(at)gmx(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bart Degryse | 2008-02-13 10:54:14 | return field from different table conditionally |
Previous Message | Richard Huxton | 2008-02-12 12:01:04 | Re: Check before INSERT INTO |