Re: GUID in postgres
От
Horst Herb
Тема
Re: GUID in postgres
Дата
Msg-id
20011025034926.30847.qmail@gnumed.dhs.org
Ответ на
Re: GUID in postgres (John Hasler)
Список
Дерево обсуждения
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 Thursday 25 October 2001 03:41, John Hasler wrote: > Josh writes: > > I'm sure you could make your own GUID, whatever one is. > > Globally Unique IDentifier, probably. Just hash a 128 bit random number > with the current date. That gives you no gurantee it will be unique. What we are using is the following: - All tables in need of a global ID _within_ a database inherit a globid table which contains nothing but an ID of type serial. - When we need cross-database unique IDs within the same system, the globid table contains a database identifier as well (like the OID of the pg_database entry for the database). Horst
В списке pgsql-sql по дате отправления
