Re: What to use for GUIDS ? - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: What to use for GUIDS ?
Date
Msg-id 20051017181049.GC86144@pervasive.com
Whole thread Raw
In response to What to use for GUIDS ?  ("Paul Newman" <pnewman@tripoint.co.uk>)
List 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 by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Problem using start transaction in nested transactions.
Next
From: Chris Travers
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase