Обсуждение: problem running uui.sql script OSSP-UUID package
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.
jordi.tablada@hyds.es writes:
> 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.
I'm not sure what uuid.sql is, but it is not the script that comes with
8.3's contrib/uuid-ossp module. Judging from the errors it might be
something that is trying to create a user-defined uuid type. That's not
going to work in 8.3 because there's already a built-in uuid type.
In short: you're trying to use some old script, not the one you want.
regards, tom lane
thanks for your answer Tom, I've installed that module contrib but there's nothing like ossp-uuid inside! I've found it through software.opensuse for my opensuse 11 version and ossp-uuid should be installed separately, or am I wrong?. I took it from http://www.ossp.org/pkg/lib/uuid/ you know something about that? the details of my postgresql-contrib: postgresql-contrib-8.3.1-15.1 - Contributed Extensions and Additions to PostgreSQL /usr/bin/oid2name /usr/bin/pg_standby /usr/bin/pgbench /usr/bin/vacuumlo /usr/lib64/postgresql /usr/lib64/postgresql/_int.so /usr/lib64/postgresql/adminpack.so /usr/lib64/postgresql/autoinc.so /usr/lib64/postgresql/btree_gist.so /usr/lib64/postgresql/chkpass.so /usr/lib64/postgresql/cube.so /usr/lib64/postgresql/dblink.so /usr/lib64/postgresql/dict_int.so /usr/lib64/postgresql/dict_xsyn.so /usr/lib64/postgresql/earthdistance.so /usr/lib64/postgresql/fuzzystrmatch.so /usr/lib64/postgresql/hstore.so /usr/lib64/postgresql/insert_username.so /usr/lib64/postgresql/int_aggregate.so /usr/lib64/postgresql/isn.so /usr/lib64/postgresql/lo.so /usr/lib64/postgresql/ltree.so /usr/lib64/postgresql/moddatetime.so /usr/lib64/postgresql/pageinspect.so /usr/lib64/postgresql/pg_buffercache.so /usr/lib64/postgresql/pg_freespacemap.so /usr/lib64/postgresql/pg_trgm.so /usr/lib64/postgresql/pgcrypto.so /usr/lib64/postgresql/pgrowlocks.so /usr/lib64/postgresql/pgstattuple.so /usr/lib64/postgresql/pgxml.so /usr/lib64/postgresql/refint.so /usr/lib64/postgresql/seg.so /usr/lib64/postgresql/sslinfo.so /usr/lib64/postgresql/tablefunc.so /usr/lib64/postgresql/test_parser.so /usr/lib64/postgresql/timetravel.so /usr/lib64/postgresql/tsearch2.so /usr/share/doc/packages/postgresql /usr/share/doc/packages/postgresql/contrib /usr/share/doc/packages/postgresql/contrib/autoinc.example /usr/share/doc/packages/postgresql/contrib/insert_username.example /usr/share/doc/packages/postgresql/contrib/moddatetime.example /usr/share/doc/packages/postgresql/contrib/refint.example /usr/share/doc/packages/postgresql/contrib/timetravel.example /usr/share/postgresql /usr/share/postgresql/contrib /usr/share/postgresql/contrib/_int.sql /usr/share/postgresql/contrib/adminpack.sql /usr/share/postgresql/contrib/autoinc.sql /usr/share/postgresql/contrib/btree_gist.sql /usr/share/postgresql/contrib/chkpass.sql /usr/share/postgresql/contrib/cube.sql /usr/share/postgresql/contrib/dblink.sql /usr/share/postgresql/contrib/dict_int.sql /usr/share/postgresql/contrib/dict_xsyn.sql /usr/share/postgresql/contrib/earthdistance.sql /usr/share/postgresql/contrib/fuzzystrmatch.sql /usr/share/postgresql/contrib/hstore.sql /usr/share/postgresql/contrib/insert_username.sql /usr/share/postgresql/contrib/int_aggregate.sql /usr/share/postgresql/contrib/isn.sql /usr/share/postgresql/contrib/lo.sql /usr/share/postgresql/contrib/ltree.sql /usr/share/postgresql/contrib/moddatetime.sql /usr/share/postgresql/contrib/pageinspect.sql /usr/share/postgresql/contrib/pg_buffercache.sql /usr/share/postgresql/contrib/pg_freespacemap.sql /usr/share/postgresql/contrib/pg_trgm.sql /usr/share/postgresql/contrib/pgcrypto.sql /usr/share/postgresql/contrib/pgrowlocks.sql /usr/share/postgresql/contrib/pgstattuple.sql /usr/share/postgresql/contrib/pgxml.sql /usr/share/postgresql/contrib/refint.sql /usr/share/postgresql/contrib/seg.sql /usr/share/postgresql/contrib/sslinfo.sql /usr/share/postgresql/contrib/tablefunc.sql /usr/share/postgresql/contrib/test_parser.sql /usr/share/postgresql/contrib/timetravel.sql /usr/share/postgresql/contrib/tsearch2.sql /usr/share/postgresql/contrib/uninstall__int.sql /usr/share/postgresql/contrib/uninstall_adminpack.sql /usr/share/postgresql/contrib/uninstall_btree_gist.sql /usr/share/postgresql/contrib/uninstall_chkpass.sql /usr/share/postgresql/contrib/uninstall_cube.sql /usr/share/postgresql/contrib/uninstall_dblink.sql /usr/share/postgresql/contrib/uninstall_dict_int.sql /usr/share/postgresql/contrib/uninstall_dict_xsyn.sql /usr/share/postgresql/contrib/uninstall_earthdistance.sql /usr/share/postgresql/contrib/uninstall_fuzzystrmatch.sql /usr/share/postgresql/contrib/uninstall_hstore.sql /usr/share/postgresql/contrib/uninstall_int_aggregate.sql /usr/share/postgresql/contrib/uninstall_isn.sql /usr/share/postgresql/contrib/uninstall_lo.sql /usr/share/postgresql/contrib/uninstall_ltree.sql /usr/share/postgresql/contrib/uninstall_pageinspect.sql /usr/share/postgresql/contrib/uninstall_pg_buffercache.sql /usr/share/postgresql/contrib/uninstall_pg_freespacemap.sql /usr/share/postgresql/contrib/uninstall_pg_trgm.sql /usr/share/postgresql/contrib/uninstall_pgcrypto.sql /usr/share/postgresql/contrib/uninstall_pgrowlocks.sql /usr/share/postgresql/contrib/uninstall_pgstattuple.sql /usr/share/postgresql/contrib/uninstall_pgxml.sql /usr/share/postgresql/contrib/uninstall_seg.sql /usr/share/postgresql/contrib/uninstall_sslinfo.sql /usr/share/postgresql/contrib/uninstall_tablefunc.sql /usr/share/postgresql/contrib/uninstall_test_parser.sql /usr/share/postgresql/contrib/uninstall_tsearch2.sql /usr/share/postgresql/tsearch_data/xsyn_sample.rules 109 files total Quoting Tom Lane <tgl@sss.pgh.pa.us>: > jordi.tablada@hyds.es writes: >> 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. > > I'm not sure what uuid.sql is, but it is not the script that comes with > 8.3's contrib/uuid-ossp module. Judging from the errors it might be > something that is trying to create a user-defined uuid type. That's not > going to work in 8.3 because there's already a built-in uuid type. > > In short: you're trying to use some old script, not the one you want. > > regards, tom lane > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
jordi.tablada@hyds.es writes: > I've installed that module contrib but there's nothing like ossp-uuid inside! > I've found it through software.opensuse for my opensuse 11 version and > ossp-uuid should be installed separately, or am I wrong?. I took it from > http://www.ossp.org/pkg/lib/uuid/ Looks like you need to complain to the opensuse packager about having omitted the uuid-ossp module. regards, tom lane