| 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: | Whole Thread | Raw Message | 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" |