Blech, looks like MySQL neither has a uniqueidentifier property nor sequences (AUTO_INCREMENT doesn’t work for shared IDs). This is pretty trivial to handle in PostgreSQL. Hmm, perhaps could be added via a UDF but this seems like a pain. Uggh, must be written in C. Que Lame-o.
(another option is using ‘uuidgen -t’, but there are a few negatives: 1) forking for each uuidgen, and at least the bigger problem for me 2) the uuid generated is a 8-4-4-4-8 hexadecimal string that’s frankly overkill (must be stored as a char, too large to store in INT4 – could be worked with, but well…)