Usage of UUID with 8.3 (Windows)

From: "Sven Sporer" <ncode(at)gmx(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Usage of UUID with 8.3 (Windows)
Date: 2008-02-12 09:05:41
Message-ID: 20080212090541.76470@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > I think Windows has its own UUID generator, so the best bet would be to
> > make that work.
>
> Only if it can be made to present the same SQL-level API as we have for
> OSSP. Otherwise we'll be faced with boatloads of platform-dependent
> client code ...

I'm just curious, but why aren't those features included in the Windows version in order to prevent platform-dependent development in that direction? The same Postgres version now essentially provides different features depending on the platform.

I understand now that you just want to provide the facilities for UUID handling (datatype). You have to agree that a function to create a v4 UUID based on a randomly generated number (see MySQL: UUID()) would be useful though.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shavonne Marietta Wijesinghe 2008-02-12 10:00:12 Re: Check before INSERT INTO
Previous Message Richard Huxton 2008-02-12 08:32:55 Re: Backward compatibility psql 8.1 to 8.2