2 ms·
It includes pgcrypto so you can use the new gen_random_uuid() from there to generate UUIDs. For the record, uuid-ossp is a steaming pile and there's no reason
by koolba 10y ago
It includes pgcrypto so you can use the new gen_random_uuid() from there to generate UUIDs.
For the record, uuid-ossp is a steaming pile and there's no reason to use it for anything on a modern Postgres install.
- shawn-butler 10y agoWhat exactly do you mean by this? Your comment is uninformative without some substance.
- koolba 10y agoThe code is pretty much unmaintained at this point, it's a pain in the ass to build, besides the v4 UUID generation function everything else in there is useless, and the v4 UUID generation function is 6x slower than the one in pgcrypto[1]. There's no reason to use it and incorporating it into projects just creates headaches down the road. [1]: https://www.postgresql.org/message-id/flat/52CF07C2.3080101%40ohmu.fi#52CF07C2.3080101@ohmu.fi https://www.postgresql.org/message-id/flat/52CF07C2.3080101%...
- clhodapp 10y agoI believe that type 5 (and I guess type 3) UUIDs both have legitimate use cases, especially when data migrations are involved. Both of these types are supported by uuid-ossp but not by pgcrypto.