pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Jonah H. Harris <jonah.harris@gmail.com>
To: nathan wagner <nw@hydaspes.if.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: uuid type for postgres
Date: Tue, 6 Sep 2005 16:32:06 -0400
Message-ID: <36e6829205090613322d300745@mail.gmail.com> (raw)
In-Reply-To: <20050906211613.GB26851@granicus.if.org>
References: <20050906135057.GA24136@granicus.if.org>
<20050906144930.GA27641@mark.mielke.cc>
<200509061002.43803.josh@agliodbs.com>
<36e6829205090612575b954f38@mail.gmail.com>
<20050906211613.GB26851@granicus.if.org>
The only time I've seen someone use UUIDs in PostgreSQL is when they were
converting from SQL Server. I've seen many bad data models using UUID that
could've/should've used normal sequences for portability.
I look forward to seeing you're code.
Thanks!
On 9/6/05, nathan wagner <nw@hydaspes.if.org> wrote:
>
> On Tue, Sep 06, 2005 at 03:57:55PM -0400, jonah.harris@gmail.com wrote:
> > I agree with Josh on the UUID type, it gets abused far too often
>
> Out of curiosity, how does it get abused? It doesn't seem to me
> that it would be any more prone to abuse than any other type.
>
> > and (IMHO) isn't widely enough used to belong in the core.
>
> Seems like a self-fulfilling cycle. There isn't one in core
> or contrib (pguuid is not in contrib, IIRC), and so one doesn't
> get used. Since no one uses one, it's not in core or contrib.
>
> > Couldn't you just fix the
> > problem in pguuid rather than write a whole new type?
>
> Not sure which you you're addressing here, but I can't fix the license
> problem. Nor can I readily fix the lack of a mac ioctl() to get
> the hardware mac address.
>
> In any case, from an economy of effort view, I'd much rather maintain
> a postgres extension/interface to an existing uuid library, than fret
> the details of writing a uuid library myself. UUIDs themselves don't
> really interest me, I just happen to need one for my application.
>
> I'm basically done. I'll tar it up and post a link to an alpha version in
> a
> couple of hours. As far as i can tell, it works fine. I'm calling it alpha
> because i'm not doing proper error checking, and i'm not sure how to log
> or
> throw an error even if i detect one. Also, I have only compiled it on
> Mac OS 10.3, I'll want to test it on my linux box.
>
> --
> Nathan Wagner
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
view thread (51+ messages) latest in thread
Message-ID: <36e6829205090613322d300745@mail.gmail.com> Permalink: ../36e6829205090613322d300745@mail.gmail.com/ Also on: postgresql.org/message-id/36e6829205090613322d300745@mail.gmail.com ·
reply
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, nw@hydaspes.if.org, pgsql-hackers@postgresql.org Subject: Re: uuid type for postgres In-Reply-To: <36e6829205090613322d300745@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