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

From: mark(at)mark(dot)mielke(dot)cc
To: Thomas Hallgren <thomas(at)tada(dot)se>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as primary keys
Date: 2006-06-28 17:14:16
Message-ID: 20060628171416.GA12191@mark.mielke.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Jun 28, 2006 at 06:39:16PM +0200, Thomas Hallgren wrote:
> Instead, I would like to humbly request the inclusion of a UUID datatype
> (or an opaque 128 bit datatype) in the core package. It's increasingly
> common and some databases (MS SQLServer) already have built in support for
> it.

We have it. We're just not putting in the effort required to have it
included in core, as it's too much effort to convince people that the
type has value, that is is generic, and would be widely used without
being abused. All the geometric types that I'll never use in core,
with few or no uses, including functions to operate on these types,
and no UUID type... Hehe... To me, that's irony... :-)

Cheers,
mark

--
mark(at)mielke(dot)cc / markm(at)ncf(dot)ca / markm(at)nortel(dot)com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada

One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...

http://mark.mielke.cc/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2006-06-28 17:18:39 Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Previous Message Jim C. Nasby 2006-06-28 17:10:53 Re: Fixed length datatypes. WAS [GENERAL] UUID's as primary keys

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-28 17:18:29 Re: Instability in TRUNCATE regression test
Previous Message Tom Lane 2006-06-28 17:13:42 Re: Instability in TRUNCATE regression test