instaling ossp-uuid

From: dunasoft(at)dunasoft(dot)es
To: pgsql-general(at)postgresql(dot)org
Subject: instaling ossp-uuid
Date: 2010-03-11 12:54:26
Message-ID: 20100311135426.y4qpv8ajqcw8sksc@www.dunasoft.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Graf 2010-03-11 13:30:08 Re: Naming conventions for lots of stored procedures
Previous Message Ashesh Vashi 2010-03-11 12:05:26 Re: how to remove super user