Skip site navigation (1) Skip section navigation (2)

Re: Fixed length datatypes. WAS [GENERAL] UUID's as

From: Thomas Hallgren <thomas(at)tada(dot)se>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, mark(at)mark(dot)mielke(dot)cc, Andrew Dunstan <andrew(at)dunslane(dot)net>, "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Martijn van Oosterhout <kleptog(at)svana(dot)org>
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Date: 2006-06-30 06:53:28
Message-ID: 44A4CA68.4030508@tada.se (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Josh Berkus wrote:
 > Jim,
 >
 >> I agree about splitting the utilities, except that I think the database
 >> should be able to generate UUIDs somehow.
 >
 > There is a GUID add-in, and someone is working on a 2nd one.  UUIDs 
are not part of the SQL standard, and we've only seen sporadic demand 
for them (and different types each time) so I can't imagine one making 
it further than contrib real soon.
 >
 > Also, one could argue that UUIDs are a foot gun, so they're not 
exactly the type of thing we want to advocate in advance of demand.
 >

Martijn van Oosterhout wrote:
 > It seems to me that maybe the backend should include a 16-byte fixed
 > length object (after all, we've got 1, 2, 4 and 8 bytes already) and
 > then people can use that to build whatever they like, using domains,
 > for example...
 >
So how about the split? I.e. just add a 16 byte data type and forget all 
about UUID's for now.

Regards,
Thomas Hallgren



In response to

Responses

pgsql-hackers by date

Next:From: markDate: 2006-06-30 08:04:19
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Previous:From: Josh BerkusDate: 2006-06-30 06:27:10
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as

pgsql-general by date

Next:From: markDate: 2006-06-30 08:04:19
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Previous:From: Alain RogerDate: 2006-06-30 06:28:24
Subject: phppgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group