From: Jonah H. Harris <jonah.harris@gmail.com>
To: josh@agliodbs.com
Cc: pgsql-hackers@postgresql.org, mark@mark.mielke.cc, nathan wagner <nw@hydaspes.if.org>
Subject: Re: uuid type for postgres
Date: Tue, 6 Sep 2005 15:57:55 -0400
Message-ID: <36e6829205090612575b954f38@mail.gmail.com> (raw)
In-Reply-To: <200509061002.43803.josh@agliodbs.com>
References: <20050906135057.GA24136@granicus.if.org>
<20050906144930.GA27641@mark.mielke.cc>
<200509061002.43803.josh@agliodbs.com>
I agree with Josh on the UUID type, it gets abused far too often and (IMHO)
isn't widely enough used to belong in the core. Couldn't you just fix the
problem in pguuid rather than write a whole new type?
On 9/6/05, Josh Berkus <josh@agliodbs.com> wrote:
>
> Mark,
>
> > I suggest that UUID be recommended in place of SERIAL for certain
> > classes of applications, and that it therefore belongs in the core.
> > UUID and SERIAL can be used together (although, once you have a UUID,
> > it may not be useful to also have a SERIAL).
>
> I think that, if you want to push a refactored UUID type for PostgreSQL
> 8.2, that you'd better separate your database design arguments from your
> inclusion arguments.
>
> For example, you might get my agreement that it would be useful to have a
> UUID as a core type; you would *never* get my agreement to recommend using
> UUID to newbies. I have seen *far* too many abuses of UUIDs in really
> bad database design. People who use them should be experienced enough to
> know what they're doing.
>
> --
> --Josh
>
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jonah.harris@gmail.com, josh@agliodbs.com, nw@hydaspes.if.org
Subject: Re: uuid type for postgres
In-Reply-To: <36e6829205090612575b954f38@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox