Обсуждение: instaling ossp-uuid

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?

On Thu, 2010-03-11 at 13:54 +0100, dunasoft@dunasoft.es wrote:
> 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
...
<snip>

Could you please try installing these uuid RPMs and test against these?

http://yum.pgrpms.org/8.3/redhat/rhel-5-x86_64/repoview/letter_u.group.html

(Replace 8.3 with 8.4 if you are using 8.4...)

I have tested it before, and it worked.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz