Skip site navigation (1) Skip section navigation (2)

How to install UUID module postgres 8.4.4

From: George H <george(dot)dma(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to install UUID module postgres 8.4.4
Date: 2010-08-24 07:48:37
Message-ID: AANLkTinLbsfsfa9Kq1syz24C6RbZ7WUhmK=KLRPHASbu@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I'm a new postgresql user and I'm looking forward to using this DB
engine to its full extent. Though I am having a bit of a problem
trying to install the OSSP UUID module for postgres.

I have installed postgresql v8.4.4 on Gentoo Linux with the uuid use
flag which installs OSS-UUID on my system. So that went ok. When I log
in to psql and try to test it with

psql> CREATE TABLE test (id UUID DEFAULT uuid(1), name TEXT);

I get this error

ERROR:  function uuid(integer) does not exist
HINT:  No function matches the given name and argument types. You
might need to add explicit type casts.

And according to
http://www.postgresql.org/docs/8.3/static/uuid-ossp.html  I tried

mydb=# SELECT uuid_generate_v1();

And I get this.

ERROR:  function uuid_generate_v1() does not exist
LINE 1: SELECT uuid_generate_v1();
               ^
HINT:  No function matches the given name and argument types. You
might need to add explicit type casts.

I have this feeling that the module is not really installed correctly
and I can't seem to find a webpage that explains how to install this
module. I even tried a manual installation of OSSP-UUID and followed
the instructions in their uuid.txt that says


  $ <prefix>/bin/psql \
    -d <database> \
    -U postgresql \
    -f <prefix>/share/postgresql/uuid.sql

And that gives me errors telling me that it cannot drop certain
functions because it is needed by the system.

Can anyone help me with this problem ?
Thanks.

--
George H
george(dot)dma(at)gmail(dot)com

pgsql-novice by date

Next:From: George HDate: 2010-08-24 08:04:48
Subject: Re: How to install UUID module postgres 8.4.4 [Solved]
Previous:From: Scott MarloweDate: 2010-08-24 05:47:35
Subject: Re: select from pipe-delimited field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group