X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8525FD8206 for ; Wed, 7 Sep 2005 15:47:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16881-03 for ; Wed, 7 Sep 2005 18:47:33 +0000 (GMT) Received: from redivi.com (redivi.com [64.207.133.54]) by svr1.postgresql.org (Postfix) with ESMTP id 7C8DDD8188 for ; Wed, 7 Sep 2005 15:47:31 -0300 (ADT) Received: from [72.1.150.252] (helo=[192.168.0.40]) by redivi.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.43) id 1ED4xD-0004dH-Dj; Wed, 07 Sep 2005 11:47:32 -0700 In-Reply-To: <20050907170430.GA6281@granicus.if.org> References: <20050906135057.GA24136@granicus.if.org> <7CDBCE29-55BE-4EE3-8868-F50DB1E914F6@refractions.net> <20050907051508.GA3572@granicus.if.org> <200509070945.17916.josh@agliodbs.com> <20050907170430.GA6281@granicus.if.org> Mime-Version: 1.0 (Apple Message framework v734) Message-Id: <914AC2C5-A81F-415B-B5AC-832A22D12ECB@redivi.com> Cc: pgsql-hackers@postgresql.org From: Bob Ippolito Date: Wed, 7 Sep 2005 11:47:23 -0700 To: nathan wagner X-Mailer: Apple Mail (2.734) X-SA-Exim-Connect-IP: 72.1.150.252 X-SA-Exim-Mail-From: bob@redivi.com Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: uuid type for postgres X-SA-Exim-Version: 4.1+cvs (built Mon, 23 Aug 2004 08:44:05 -0700) X-SA-Exim-Scanned: Yes (on redivi.com) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 required=5 tests=[AWL=0.007] X-Spam-Level: X-Archive-Number: 200509/363 X-Sequence-Number: 72760 On Sep 7, 2005, at 10:04 AM, nathan wagner wrote: > On Wed, Sep 07, 2005 at 09:45:17AM -0700, josh@agliodbs.com wrote: > > >> I think the issue is portability. Remember that this type needs >> to work on >> Windows as well as all POSIX platforms and AIX. >> > > I had forgotten about windows. I'll see to what extent the library > i'm > using is portable to windows. You don't need to use a non-standard library for a lot of platforms, you're pretty much guaranteed UUID support for (at least): Linux/Darwin/Mac OS X: uuid_generate (part of libc, at least on Darwin) FreeBSD: uuid_create (again, libc) Windows: UuidCreate (link to Rpcrt4.dll, IIRC) Where a native UUID generate is not available, you can include some implementation, but surely other platforms also include UUID implementations. I think Windows portability is a non-issue here. -bob