Received: from ajax2.sovam.com (ajax2.sovam.com [194.67.1.173]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9QNWKP41902 for ; Fri, 26 Oct 2001 19:32:20 -0400 (EDT) (envelope-from dmitry@taurussoft.org) Received: from ts18-a384.dial.sovam.com ([195.239.6.130]:4704 "HELO hq.taurussoft.org" ident: "TIMEDOUT2" whoson: "tttt@online.ru" smtp-auth: TLS-CIPHER: TLS-PEER: ) by ajax2.sovam.com with SMTP id convert rfc822-to-8bit; Sat, 27 Oct 2001 03:32:06 +0400 Received: (qmail 22831 invoked from network); 26 Oct 2001 23:31:26 -0000 Received: from flame-in-night.hq.taurussoft.org (192.168.107.1) by kitezh.hq.taurussoft.org with SMTP; 26 Oct 2001 23:31:26 -0000 Received: (qmail 1074 invoked from network); 26 Oct 2001 23:31:34 -0000 Received: from localhost (127.0.0.1) by localhost with SMTP; 26 Oct 2001 23:31:34 -0000 Subject: Re: GUID in postgres From: "Dmitry G. Mastrukov" =?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?= =?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?= =?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?= To: postgresql_sql@kaiserdigital.com Cc: pgsql-sql@postgresql.org In-Reply-To: <003501c15e41$a643a220$0c00a8c0@mouse> References: <003501c15e41$a643a220$0c00a8c0@mouse> Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: 8BIT X-Mailer: Evolution/0.15 (Preview Release) Date: 27 Oct 2001 03:31:04 +0400 Message-Id: <1004139094.781.21.camel@flame-in-night> Mime-Version: 1.0 X-Archive-Number: 200110/378 X-Sequence-Number: 5330 On ِشخ, 2001-10-26 at 21:14, postgresql_sql@kaiserdigital.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