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@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.
