Re: GUID in postgres
От
Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков
Тема
Re: GUID in postgres
Дата
Msg-id
1004139094.781.21.camel@flame-in-night
Ответ на
Список
Дерево обсуждения
GUID in postgres "Dinesh Parikh" <dineshp@newgen.co.in>
Re: GUID in postgres "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
Re: GUID in postgres <postgresql_sql@kaiserdigital.com>
Re: GUID in postgres "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
Re: GUID in postgres "Josh Berkus" <josh@agliodbs.com>
Re: GUID in postgres <postgresql_sql@kaiserdigital.com>
Re: GUID in postgres "Josh Berkus" <josh@agliodbs.com>
Re: GUID in postgres "Josh Berkus" <josh@agliodbs.com>
Cross-posting (was Re: GUID in postgres) Tom Lane <tgl@sss.pgh.pa.us>
Re: GUID in postgres John Hasler <john@dhh.gt.org>
Re: GUID in postgres Horst Herb <hherb@malleenet.net.au>
Re: GUID in postgres John Hasler <john@dhh.gt.org>
Re: GUID in postgres "Josh Berkus" <josh@agliodbs.com>
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
В списке pgsql-sql по дате отправления