Re: problem running uui.sql script OSSP-UUID package

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(at)sss(dot)pgh(dot)pa(dot)us>:

> jordi(dot)tablada(at)hyds(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>

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