On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote: >> My production server is running Postgres 9.0 on Ubuntu Server, and I'm >> getting some errors in sprocs that call uuid_generate_v1().. This is >> because the function is missing. >> >> On my Windows box, this function would automatically be installed as >> part of the database.. If I try to create the function with: >> >> >> CREATE OR REPLACE FUNCTION uuid_generate_v1() >> RETURNS uuid AS >> '$libdir/uuid-ossp', 'uuid_generate_v1' >> LANGUAGE c VOLATILE STRICT >> COST 1; >> >> I get: >> >> ERROR: could not load library >> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: >> cannot open shared object file: No such file or directory >> SQL state: 58P01 >> >> How do I get this working under Linux? Thanks!! > > Have you installed the contrib package? Often there's an associated > .sql file to turn a contrib module on in a given database. It'll be > in something like /usr/share usually Yup, I tried that - Here's what I get: # ./psql -d ****** -U ****** -f /opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql Password for user root: SET psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:9: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:14: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:19: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:24: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:29: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:34: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:39: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:44: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:49: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:54: ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
