Postgres - uuid-ossp error

From: Adalberto Costa <adalbertodiascosta(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres - uuid-ossp error
Date: 2009-06-21 14:05:49
Message-ID: 344f44d20906210705u351501a4l104e69e867f1538@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm trying to create a simple function using uuid-ossp package like follows:

CREATE OR REPLACE FUNCTION uuid_nil()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_nil'
IMMUTABLE STRICT LANGUAGE C;

But, I'm getting an error like below:

ERROR: ERROR: could not load library
"/Applications/MAMP/Library/pg/lib/postgresql/uuid-ossp.so":
dlopen(/Applications/MAMP/Library/pg/lib/postgresql/uuid-ossp.so,
10): no suitable
image found. Did find:
/Applications/MAMP/Library/pg/lib/postgresql/uuid-ossp.so:
mach-o, but wrong architecture

Query
= CREATE OR REPLACE FUNCTION uuid_nil()
RETURNS uuid
AS '$libdir/uuid-ossp',
'uuid_nil'
IMMUTABLE STRICT LANGUAGE C

I'm using mac OS-X 10.4 and Postgres 8.3.5 . Can someone help me?

--
Adalberto Dias Costa
Instituto Tecnológico de Aeronáutica - ITA
Sala 78 - Laboratório de Aprendizagem e Interação - LAI
Fone (12) 3947-6869.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-21 14:38:41 Re: Implicit conversion/comparision of timestamp with and without timezone
Previous Message Stephen Frost 2009-06-21 13:45:24 Re: Build in spatial support vs. PostGIS