我的問(wèn)題很簡(jiǎn)單。我知道UUID的概念,我想生成一個(gè)引用UDB的“存儲(chǔ)”中的每個(gè)“項(xiàng)目”??雌饋?lái)合理吧?問(wèn)題是以下行返回錯(cuò)誤:honeydb=# insert into items values(uuid_generate_v4(), 54.321, 31, 'desc 1', 31.94);ERROR: function uuid_generate_v4() does not existLINE 2: uuid_generate_v4(), 54.321, 31, 'desc 1', 31.94); ^HINT: No function matches the given name and argument types. You might need to add explicit type casts.我已在以下位置閱讀該頁(yè)面:http : //www.postgresql.org/docs/current/static/uuid-ossp.html我在Ubuntu 10.04 x64上運(yùn)行Postgres 8.4。
在Postgres中為插入語(yǔ)句生成UUID?
HUH函數(shù)
2019-12-07 15:37:29