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.dma@gmail.com