From: | "Morris, Roy" <rmorris(at)internetsecure(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: UUId or Similar |
Date: | 2009-01-28 15:05:31 |
Message-ID: | 19BA112CA339EB47B0E90EBAE50D132D0354324A@exch1.internal.priv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Yes all I get is a bunch of errors, I am running Openbsd 4.4 not linux,
although I did install the uuid 1.62? I think and it works fine on the
OS.
logsvr:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp# uuid
0d1765d2-55a5-11de-aa2c-000f1f69cc7e
I am not sure if the actual errors are of any value but here they are ..
IIS_Logs=# \i /home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql
SET
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_nil()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_nil'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:9: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_ns_dns()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_ns_dns'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:14: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_ns_url()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_ns_url'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:19: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_ns_oid()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_ns_oid'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:24: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_ns_x500()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_ns_x500'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:29: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_generate_v1()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v1'
VOLATILE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:34: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_generate_v1mc()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v1mc'
VOLATILE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:39: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_generate_v3(namespace uuid, name text)
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v3'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:44: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_generate_v4()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v4'
VOLATILE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:49: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE OR REPLACE FUNCTION uuid_generate_v5(namespace uuid, name text)
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v5'
IMMUTABLE STRICT LANGUAGE C;
psql:/home/rmorris/postgresql-8.3.5/contrib/uuid-ossp/uuid-ossp.sql:54: ERROR: incompatible library "/usr/local/pgsql/lib/uuid-ossp": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of A. Kretschmer
Sent: Wednesday, January 28, 2009 9:56 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] UUId or Similar
In response to Morris, Roy :
> Hi, it seems every time I install a new version of postgres I go through
> this same fight with trying to get UUID to install, Ugg! Anyway in this
test=# \i '/usr/share/postgresql/8.3/contrib/uuid-ossp.sql';
test=# select * from uuid_generate_v1();
uuid_generate_v1
--------------------------------------
b3a24ab0-ed4b-11dd-8593-00138f82c65e
(1 row)
version: 8.3.5
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-01-28 16:49:29 | Re: JOIN vs. LEFT JOIN |
Previous Message | A. Kretschmer | 2009-01-28 14:56:20 | Re: UUId or Similar |