关于postgresql使用uuid的几个注意点

最新推荐文章于 2025-06-16 21:02:33 发布

转载最新推荐文章于 2025-06-16 21:02:33 发布 · 789 阅读

文章标签：

#pg #postgresql #uuid #uuid-ossp

Linux 同时被 2 个专栏收录

292 篇文章

订阅专栏

PostgreSQL

211 篇文章

订阅专栏

本文介绍 PostgreSQL 的 uuid-ossp 模块，该模块最初依赖于 OSSP UUID 库。随着库维护困难增加，uuid-ossp 开始支持 BSD 和 e2fsprogs 的 libuuid 库。文章详细解释了如何根据不同平台选择合适的 UUID 创建函数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

https://www.postgresql.org/docs/10/uuid-ossp.html

Historically this module depended on the OSSP UUID library, which accounts for the module's name. While the OSSP UUID library can still be found at http://www.ossp.org/pkg/lib/uuid/, it is not well maintained, and is becoming increasingly difficult to port to newer platforms. uuid-ossp can now be built without the OSSP library on some platforms. On FreeBSD, NetBSD, and some other BSD-derived platforms, suitable UUID creation functions are included in the core libc library. On Linux, macOS, and some other platforms, suitable functions are provided in the libuuid library, which originally came from the e2fsprogsproject (though on modern Linux it is considered part of util-linux-ng). When invoking configure, specify --with-uuid=bsd to use the BSD functions, or --with-uuid=e2fs to use e2fsprogs' libuuid, or --with-uuid=ossp to use the OSSP UUID library. More than one of these libraries might be available on a particular machine, so configure does not automatically choose one.