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
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" |