Sabin Coanda wrote: > I run the following script and now it works: > > CREATE OR REPLACE FUNCTION uuid_generate_v1() > RETURNS uuid > AS '$libdir/uuid-ossp', 'uuid_generate_v1' > VOLATILE STRICT LANGUAGE C; > > Similar for all the other defined uuid functions.
There should be a uuid-ossp.sql file with all those definitions in. Also an "uninstall" version of the file too. > Unfortunatelly I experienced the same problem on linux version 8.3.5. after > I installed the package. But there the same script doesn't work, and logs > that the file is not found. The uuid-ossp.so file? Is it in the right directory? Is it readable by the postgres user? -- Richard Huxton Archonet Ltd -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
