pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

linux. ossp-uuid
3+ messages / 3 participants
[nested] [flat]

* linux. ossp-uuid
@ 2010-12-21 08:31  =?KOI8-R?B?7snLz8zByiDp1snLz9c=?= <nizhikov@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Николай Ижиков @ 2010-12-21 08:31 UTC (permalink / raw)
  To: pgsql-sql

Hi, guys.

I have linux server. Package uuid installed

I build and install postgresql from source with --with-ossp-uuid flag.

After installation I try to execute:

=======
create or replace function uuid_generate_v1() returns uuid as
'$libdir/uuid-ossp', 'uuid_generate_v1' volatile strict language C
=======

and got error

"could not load libraty /usr/lib/postgresql/uuid-ossp.so":
/usr/lib/postgresql/uuid-ossp.so: undefined symbol: uuid_error"

How I can fix it?


-- 
С уважением, Николай Ижиков
NIzhikov@gmail.com

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: linux. ossp-uuid
@ 2010-12-21 11:06  Trinath Somanchi <trinath.somanchi@gmail.com>
  parent: =?KOI8-R?B?7snLz8zByiDp1snLz9c=?= <nizhikov@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Trinath Somanchi @ 2010-12-21 11:06 UTC (permalink / raw)
  To: Николай Ижиков <nizhikov@gmail.com>; +Cc: pgsql-sql

Hi-
Do u want to add UUID support to postgresql
follow this link

http://raveica.comdurav.com/blog/personal/how-do-i-add-uuid-to-postgresql/

or for UUID-OSSP, here is the documentation
http://www.postgresql.org/docs/8.3/static/uuid-ossp.html

2010/12/21 Николай Ижиков <nizhikov@gmail.com>

> Hi, guys.
>
> I have linux server. Package uuid installed
>
> I build and install postgresql from source with --with-ossp-uuid flag.
>
> After installation I try to execute:
>
> =======
> create or replace function uuid_generate_v1() returns uuid as
> '$libdir/uuid-ossp', 'uuid_generate_v1' volatile strict language C
> =======
>
> and got error
>
> "could not load libraty /usr/lib/postgresql/uuid-ossp.so":
> /usr/lib/postgresql/uuid-ossp.so: undefined symbol: uuid_error"
>
> How I can fix it?
>
>
> --
> С уважением, Николай Ижиков
> NIzhikov@gmail.com
>



-- 
Regards,
----------------------------------------------
Trinath Somanchi,

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: linux. ossp-uuid
@ 2010-12-22 02:00  Basil Bourque <basil.list@me.com>
  parent: =?KOI8-R?B?7snLz8zByiDp1snLz9c=?= <nizhikov@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Basil Bourque @ 2010-12-22 02:00 UTC (permalink / raw)
  To: pgsql-sql

As documented here:
http://www.postgresql.org/docs/9.0/interactive/uuid-ossp.html

Rather than assuming the host operating system has an implementation of UUID, Postgres depends on the presence of a specific implementation of UUID generation & handling. This open-source implementation is called "OSSP uuid", found here:
http://www.ossp.org/pkg/lib/uuid/

My guess:
You compiled the code necessary for Postgres to reach out to this UUID implementation. But you are missing the actual UUID implementation.

The OneClick installer from EnterpriseDB.com placed this on my Mac, which I assume is the UUID implementation:
/Library/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so

In addition I found what I assume is the code that enables Postgres to reach out and call that implementation.
/Library/PostgreSQL/9.0/lib/libuuid.dylib
/Library/PostgreSQL/9.0/lib/libuuid.la

Lastly I found this SQL script which I ran to enable the already-complied code:
/Library/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql

I'm no expert, but I hope that helps.

--Basil Bourque

> I have linux server. Package uuid installed
> 
> I build and install postgresql from source with --with-ossp-uuid flag.
> 
> After installation I try to execute:
> 
> =======
> create or replace function
>  uuid_generate_v1()
> 
> returns
>  uuid
> 
> as '$libdir/uuid-ossp', 'uuid_generate_v1'
> 
> volatile strict language C
> 
> =======
> 
> and got error
> 
> "could not load libraty /usr/lib/postgresql/uuid-ossp.so": /usr/lib/postgresql/uuid-ossp.so: undefined symbol: uuid_error"
> 
> How I can fix it?





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2010-12-22 02:00 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-21 08:31 linux. ossp-uuid =?KOI8-R?B?7snLz8zByiDp1snLz9c=?= <nizhikov@gmail.com>
2010-12-21 11:06 ` Trinath Somanchi <trinath.somanchi@gmail.com>
2010-12-22 02:00 ` Basil Bourque <basil.list@me.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox