On Thu, 2011-10-20 at 16:26 +0000, Morris, Roy wrote:
> It's installed via yum and installs 8.4.9 which should be fine that's
> what's running on the X86 boxes. I install at the same time the
> contrib package but alas no uuid.
It is there?
$ rpm -qlp postgresql-contrib-8.4.9-1PGDG.rhel5.i386.rpm |grep uuid
/usr/lib/pgsql/uuid-ossp.so
/usr/share/doc/postgresql-contrib-8.4.9/uninstall_uuid-ossp.sql
/usr/share/doc/postgresql-contrib-8.4.9/uuid-ossp.sql
/usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
/usr/share/pgsql/contrib/uuid-ossp.sql
You need to run uuid-ossp.sql in the database to actually be able to use it .
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
