On Wed, Jun 28, 2006 at 09:01:49AM +0200, Thomas Hallgren wrote: > I'm building an app where I have several entities that are identified > using a UUID (i.e. a 128 bit quantity). My current implementation uses a > composite primary key consisting of two int8 values. It's a bit > cumbersome and I would much rather have a distinct type. An earlier > implementation using Oracle mapped the UUID to a RAW(16) but PostgreSQL > doesn't have that and the BYTEA adds extra overhead. > > What would be the best (as in most efficient) mapping for a 128 bit > primary key?
Sounds like something for a custom type. There's one here[1] though I have no idea how good it is. [1] http://gborg.postgresql.org/project/pguuid/projdisplay.php Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
