Re: What to use for GUIDS ?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: What to use for GUIDS ?
Дата
Msg-id 20051017181049.GC86144@pervasive.com
обсуждение исходный текст
Ответ на What to use for GUIDS ?  ("Paul Newman" <pnewman@tripoint.co.uk>)
Список pgsql-general
Google for 'postgresql uuid' will reveal some options.

On Mon, Oct 17, 2005 at 09:03:17AM +0100, Paul Newman wrote:
> Hi,
>
> We are using GUIDS as primary keys. At the moment we're using a varchar
> 32. We'd like to use varchar 16 but had some problems with the generated
> chars; we were using UNICODE locale (we're now using WIN1251). Should we
> use bytea, retry varchar 16 (with the new local), or some other column
> type ?? What is going to give us the best performance (with 8.1) ?
>
>
>
> Thank You
>
>
>
> Paul Newman
>

--
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-general по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Problem using start transaction in nested transactions.
Следующее
От: Chris Travers
Дата:
Сообщение: Re: [pgsql-advocacy] Oracle buys Innobase