Re: uuid type for postgres

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: uuid type for postgres
Дата
Msg-id 200509061002.43803.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: uuid type for postgres  (mark@mark.mielke.cc)
Ответы Re: uuid type for postgres  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
Mark,

> I suggest that UUID be recommended in place of SERIAL for certain
> classes of applications, and that it therefore belongs in the core.
> UUID and SERIAL can be used together (although, once you have a UUID,
> it may not be useful to also have a SERIAL).

I think that, if you want to push a refactored UUID type for PostgreSQL 
8.2, that you'd better separate your database design arguments from your 
inclusion arguments.   

For example, you might get my agreement that it would be useful to have a 
UUID as a core type; you would *never* get my agreement to recommend using 
UUID to newbies.   I have seen *far* too many abuses of UUIDs in really 
bad database design.   People who use them should be experienced enough to 
know what they're doing.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Attention PL authors: want to be listed in template table?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Mysteriously lost values in nodes