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

Re: UUID data format 4x-4x-4x-4x-4x-4x-4x-4x

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UUID data format 4x-4x-4x-4x-4x-4x-4x-4x
Date: 2008-02-29 00:09:45
Message-ID: 20080229000945.GK1653@frubble.xen.chris-lamb.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Feb 28, 2008 at 06:45:18PM -0500, Mark Mielke wrote:
> My personal opinion is that this is entirely a philosophical issue, and 
> that both sides have merits. 

I think it depends on what you're optimising for: initial development
time, maintaince time or run time.

> There is no reason for PostgreSQL to 
> support all formats, not matter how non-standard, for every single type. 
> So, why would UUID be special? Because it's easy to do is not 
> necessarily a good reason. But then, it's not a bad reason either.

I never really buy the "performance" argument.  I much prefer the
correctness argument, if the code is doing something strange I'd prefer
to know about it as soon as possible.  This generally means that I'm
optimising for maintaince.

It's a similar argument to why lots of automatic casts were removed from
8.3, it generally doesn't hurt but the few times it does it's going to
be bad and if you're doing something strange to start with it's better
to be explicit about it.


  Sam

In response to

pgsql-hackers by date

Next:From: Dawid KuroczkoDate: 2008-02-29 00:46:22
Subject: Re: Proposal: wildcards in pg_service.conf
Previous:From: James MansionDate: 2008-02-29 00:07:33
Subject: Re: UUID data format 4x-4x-4x-4x-4x-4x-4x-4x

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