Re: GUID in postgres

From: "Dmitry G(dot) Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry(at)taurussoft(dot)org>
To: postgresql_sql(at)kaiserdigital(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: GUID in postgres
Date: 2001-10-26 23:31:04
Message-ID: 1004139094.781.21.camel@flame-in-night
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Птн, 2001-10-26 at 21:14, postgresql_sql(at)kaiserdigital(dot)com wrote:
> Hi
>
> I think most of you are missing the point here.
>
I'm missing nothing :)
"uniqueidentifier" (128-bit unique value) data type fot PostgresSQL
exists and is used at least by me. It utilizes functionality of uuid
library from widely used in Linux e2fsprogs package. Uuid library itself
can generate UUIDs with MAC/time but if /dev/urandom was detected the
true random 16 bytes will be used by default.
And yes, this type is great for primary keys.

Regards,
Dmitry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sheer El-Showk 2001-10-27 02:57:27 concurrency performance degradation
Previous Message Tom Lane 2001-10-26 23:30:33 Re: Broken pipes

Browse pgsql-sql by date

  From Date Subject
Next Message Jack 2001-10-27 00:18:12 Problems of Temporary table
Previous Message Josh Berkus 2001-10-26 20:00:04 Re: GUID in postgres