problem running uui.sql script OSSP-UUID package

From: jordi(dot)tablada(at)hyds(dot)es
To: pgsql-admin(at)postgresql(dot)org
Subject: problem running uui.sql script OSSP-UUID package
Date: 2008-10-10 12:05:22
Message-ID: 20081010140522.pxkx67gwjk0gk8os@webmail.hyds.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everybody, I'm a newcomer and I've started to work with postgresql this week
:)

I'm running on a openSuse 11 and postgresql 8.3 and I've installed ossp-uui. The
problem is when I try to execute the uuid.sql, it doesn't work.

hyds(at)tierra:/usr/lib64/postgresql> psql -U postgres -f
/usr/share/postgresql/uuid.sql
Password for user postgres:
SET
SET
psql:/usr/share/postgresql/uuid.sql:37: ERROR: cannot drop function
uuid_in(cstring) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:38: ERROR: cannot drop function
uuid_out(uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:39: ERROR: cannot drop function
uuid_recv(internal) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:40: ERROR: cannot drop function
uuid_send(uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:41: ERROR: cannot drop type uuid because it
is required by the database system
psql:/usr/share/postgresql/uuid.sql:42: ERROR: cast from type cstring to type
uuid does not exist
psql:/usr/share/postgresql/uuid.sql:43: ERROR: cast from type uuid to type
cstring does not exist
psql:/usr/share/postgresql/uuid.sql:45: ERROR: function uuid(cstring) does not
exist
psql:/usr/share/postgresql/uuid.sql:46: ERROR: function uuid(integer) does not
exist
psql:/usr/share/postgresql/uuid.sql:47: ERROR: function uuid(integer, cstring,
cstring) does not exist
psql:/usr/share/postgresql/uuid.sql:49: ERROR: function uuid_eq(uuid) does not
exist
psql:/usr/share/postgresql/uuid.sql:50: ERROR: function uuid_ne(uuid) does not
exist
psql:/usr/share/postgresql/uuid.sql:51: ERROR: cannot drop function
uuid_lt(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:52: ERROR: cannot drop function
uuid_gt(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:53: ERROR: cannot drop function
uuid_le(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:54: ERROR: cannot drop function
uuid_ge(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:55: ERROR: cannot drop operator =(uuid,uuid)
because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:56: ERROR: cannot drop operator
<>(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:57: ERROR: cannot drop operator <(uuid,uuid)
because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:58: ERROR: cannot drop operator >(uuid,uuid)
because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:59: ERROR: cannot drop operator
<=(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:60: ERROR: cannot drop operator
>=(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:62: ERROR: cannot drop function
uuid_hash(uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:63: ERROR: cannot drop function
uuid_cmp(uuid,uuid) because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:64: ERROR: cannot drop operator class
uuid_ops for access method hash because it is required by the database system
psql:/usr/share/postgresql/uuid.sql:65: ERROR: cannot drop operator class
uuid_ops for access method btree because it is required by the database system
BEGIN
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:/usr/share/postgresql/uuid.sql:101: ERROR: function uuid_out(public.uuid)
does not exist
psql:/usr/share/postgresql/uuid.sql:104: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:119: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:124: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:129: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:138: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:143: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:148: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:153: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:158: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:163: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:170: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:177: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:185: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:193: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:201: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:209: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:218: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:223: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:228: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:/usr/share/postgresql/uuid.sql:237: ERROR: current transaction is aborted,
commands ignored until end of transaction block
ROLLBACK

I've checked the dependencies between libraries and all seems to be OK. When
I've installed the ossp-uuid, I've done the configure with --with-pgsql and it
seemed to be allright...
Any idea people?

Thanks in advance :)

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-10-10 12:53:13 Re: problem running uui.sql script OSSP-UUID package
Previous Message H. Hall 2008-10-10 11:07:27 Re: can I update multiple table at a time?