Re: contrib uuid X64

I'm confused. So you're saying that I need to install which extra package to get uuid going? I have installed uuid-1.6 compiled on the box with the ./configure --with-pgsql and it all goes fine and make install works. I run the uuid.sql script and it's not happy.

psql:/home/rmorris/uuid-ossp.sql:14: ERROR: could not find function "uuid_ns_dns" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:19: ERROR: could not find function "uuid_ns_url" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:24: ERROR: could not find function "uuid_ns_oid" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:29: ERROR: could not find function "uuid_ns_x500" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:34: ERROR: could not find function "uuid_generate_v1" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:39: ERROR: could not find function "uuid_generate_v1mc" in file "/usr/lib64/pgsql/uuid.so"

Any help or advice would be great. I'd hate to have to reinstall 10 servers with FC14 or something to get this working.

Roy

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, October 20, 2011 1:20 PM
To: Morris, Roy
Cc: Devrim GÜNDÜZ; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] contrib uuid X64

"Morris, Roy" <rmorris(at)internetsecure(dot)com> writes:
> 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.

If you're speaking of the Red Hat-provided "postgresql84" RPMs, they
don't include contrib/uuid because Red Hat doesn't ship the underlying
uuid package in RHEL5.

I think it's available in EPEL, and possibly Devrim's packaging of PG
for RHEL5 relies on that copy ... but I can't very well ship a RHEL core
package with an EPEL dependency :-(

regards, tom lane
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. This message has been scanned for known computer viruses.