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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
