I just downloaded and compiled UUID on CENTOS 5.4 x86, I also
downloaded, compiled and installed ossp-uuid
and to install it i execute this as postgres user:
psql -d test_database -U postgres -f /usr/share/pgsql/uuid.sql
SET
SET
psql:/usr/share/pgsql/uuid.sql:37: ERROR: function uuid_in(cstring)
does not exist
psql:/usr/share/pgsql/uuid.sql:38: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:39: ERROR: function
uuid_recv(internal) does not exist
psql:/usr/share/pgsql/uuid.sql:40: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:41: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:42: ERROR: target data type uuid does
not exist
psql:/usr/share/pgsql/uuid.sql:43: ERROR: source data type uuid does
not exist
psql:/usr/share/pgsql/uuid.sql:45: ERROR: function uuid(cstring) does
not exist
psql:/usr/share/pgsql/uuid.sql:46: ERROR: function uuid(integer) does
not exist
psql:/usr/share/pgsql/uuid.sql:47: ERROR: function uuid(integer,
cstring, cstring) does not exist
psql:/usr/share/pgsql/uuid.sql:49: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:50: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:51: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:52: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:53: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:54: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:55: ERROR: type uuid does not exist
psql:/usr/share/pgsql/uuid.sql:56: ERROR: type uuid does not exist
psql:/usr/share/pgsql/uuid.sql:57: ERROR: type uuid does not exist
psql:/usr/share/pgsql/uuid.sql:58: ERROR: type uuid does not exist
psql:/usr/share/pgsql/uuid.sql:59: ERROR: type uuid does not exist
psql:/usr/share/pgsql/uuid.sql:60: ERROR: type uuid does not exist
psql:/usr/share/pgsql/uuid.sql:62: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:63: ERROR: type "uuid" does not exist
psql:/usr/share/pgsql/uuid.sql:64: ERROR: operator class "uuid_ops"
does not exist for access method "hash"
psql:/usr/share/pgsql/uuid.sql:65: ERROR: operator class "uuid_ops"
does not exist for access method "btree"
BEGIN
psql:/usr/share/pgsql/uuid.sql:76: ERROR: could not load library
"/usr/lib/pgsql/uuid.so": libuuid.so.16: cannot open shared object
file: No such file or directory
psql:/usr/share/pgsql/uuid.sql:81: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:86: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:91: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:101: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:104: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:119: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:124: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:129: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:138: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:143: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:148: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:153: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:158: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:163: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:170: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:177: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:185: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:193: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:201: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:209: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:218: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:223: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:228: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/uuid.sql:237: ERROR: current transaction is
aborted, commands ignored until end of transaction block
ROLLBACK
any ideas?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general