Re: [GENERAL] UUID's as primary keys

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: [GENERAL] UUID's as primary keys
Дата
Msg-id 5A5C5031-BE8D-474D-96BF-4374A420D881@pervasive.com
обсуждение исходный текст
Ответ на Re: [GENERAL] UUID's as primary keys  (Thomas Hallgren <thomas@tada.se>)
Ответы Re: [GENERAL] UUID's as primary keys  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: [GENERAL] UUID's as primary keys  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers
On Jul 6, 2006, at 4:02 PM, Thomas Hallgren wrote:
>> In answer to your question, though my opinion carries no special  
>> weight at
>> all, I would suggest adding a bare bones 16-byte data type to core  
>> and a
>> second binary-compatible data type based on it that parsed/output  
>> as uuids.
>> The extended uuid libraries should only go in pgfoundry/contrib.
> I second that.

+1. If there's enough user demand we can look at adding the type to  
core (I don't see any real advantage to contrib over pgFoundry for  
this). I'm not sure if it makes sense to add a generic 16 byte RAW to  
core, either. I'd *much* rather see effort expended on a generic RAW  
type which had it's size defined as part of the type and didn't use  
varlena.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: lastval exposes information that currval does not
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Const warnings in psql