uuid type for postgres

From: nathan wagner <nw(at)hydaspes(dot)if(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: uuid type for postgres
Date: 2005-09-06 13:50:57
Message-ID: 20050906135057.GA24136@granicus.if.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

I have been in need of a uuid type and ran across the pguuid download
by Xiongjian (Mike) Wang. This wasn't really useful to me for two
reasons: first, it is GPLed and I would prefer a more liberal license,
secondly, it didn't compile cleanly on Mac OS 10.3, due to lack of a
SIOCGETIFHWADDR (? i think, i can get the exact name if you want it)
ioctl() under darwin.

While I could dike out the code that calls it, that seems like a suboptimal
solution. So after a bit of poking around the interweb i ran across
Ralf Engelschall's ossp uuid library. This compiled with minimal
effort on mac os. Some reading, and an evening later, i've made
a server plugin with supporting SQL that implements an 'ossp_uuid'
type.

Now i have four questions:

1: Is it feasible for this to be included in the contrib section of
the regular download? The uuid library is a "notice of copyright" style
license, and I am willing to put my own code into the public domain.

2: Would just calling the type 'uuid' be better than 'ossp_uuid'? It's
certainly a nicer name.

3: Would it be possible to include such a type as a postgres extension
to the usual SQL types. It seems to me that having an officially
supported type would be better than a user contributed type on the grounds
that you could then rely on it being avaiable if postgres was.
In particular, installing it as an extension would require the cooperation
of the DBA, which may be infeasible in some environments.

--
Nathan Wagner

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mark 2005-09-06 14:49:30 Re: uuid type for postgres
Previous Message Patrick Welche 2005-09-06 12:12:50 Re: inet increment with int

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2005-09-06 14:00:33 Re: ERROR: syntax error at or near "select" at character 9
Previous Message Harald Fuchs 2005-09-06 08:57:58 Re: ERROR: syntax error at or near "select" at character 9