i have installed MOSS succefull, but starting moss_backend give me the following error :
Code: Select all
1388089931.025377 INFO backend: Backend startup 1388089932.362669 WARN backend: SQL error in Call_initvault: ERROR: function uuid() does not exist LINE 1: ...ROM createage('Neighborhood', 'Bevin', 'DRC', '', uuid(), NU... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT v_agenode FROM createage('Neighborhood', 'Bevin', 'DRC', '', uuid(), NULL) CONTEXT: PL/pgSQL function initvault() line 152 at SQL statement
I have the Source compiled and installed in the moss home-directory .
When adding the moss.sql-file to the Database, i got some errors but it seems to me all needed stuff is added
to the Database (my SQL-knowlege is near Zero). The moss.sql file is unchanged.
I am using Gentoo-Linux with PostgreSQL 9.3.2
Some help to soving this issue is needed.
regards and thank you