Re: contrib uuid X64

Thanks all. I compiled from source and it all just worked! Thanks again.

-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] 
Sent: Friday, October 21, 2011 4:50 AM
To: Morris, Roy
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] contrib uuid X64

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
CertifiedEngineer
 
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org  Twitter:
http://twitter.com/devrimgunduz
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it
isaddressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other
useof, or taking of any action in reliance upon, this information by persons or entities other than the intended
recipientis prohibited. This message has been scanned for known computer viruses.