UUID generation functions

From: "Hyatt, Gordon" <Gordon(dot)Hyatt(at)joslin(dot)harvard(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: UUID generation functions
Date: 2008-06-02 18:52:42
Message-ID: 85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sorry for the OT post, but does anyone know if there are any internal
UUID generation functions in pg? I took a quick look at the 8.2 docs
and didn't find anything related.

I know I can spawn a call to the underlying system to get a UUID. The
problem is that calling out to the system for this tends to lock one
into a specific O/S. In the case of Linux, uuidgen is _usually_
available for this; on Windows, however, a custom app to call a specific
API would be necessary.

The idea I had was to call this internal UUID generation function in an
INSERT trigger to generate a unique, traceable that identifies a sample
as it traverses numerous information systems/databases.

Thanks in advance,

Gord Hyatt

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2008-06-02 19:19:05 Re: UUID generation functions
Previous Message Filip Krška 2008-06-02 12:55:09 invalid page header in block 29 of relation "pg_type"