Postgres Error on Installation - Joomla! Forum - community, help and support
on installing postgresql database, encountered following error:
i'm using http://www.elephantsql.com/ database host. when connected databse via psql , ran same command, got message: "error: must owner of function soundex".
two questions: error matter? i'm not postgresql expert, believe function exists, maybe doesn't matter if joomla creates different version of it? did cause installation abort though. secondly, if issue, fixes?
code: select all
jlib_database_query_failed sql=create or replace function soundex(input text) returns text immutable strict cost 500 language plpgsql $$ declare soundex text = ''; char text; symbol text; last_symbol text = ''; pos int = 1; begin while length(soundex) < 4 loop char = upper(substr(input, pos, 1)); pos = pos + 1; case char when '' -- end of input string if soundex = '' return ''; else return rpad(soundex, 4, '0'); end if; when 'b', 'f', 'p', 'v' symbol = '1'; when 'c', 'g', 'j', 'k', 'q', 's', 'x', 'z' symbol = '2'; when 'd', 't' symbol = '3'; when 'l' symbol = '4'; when 'm', 'n' symbol = '5'; when 'r' symbol = '6'; else -- not consonant; no output, next similar consonant re-recorded symbol = ''; end case; if soundex = '' -- first character; accept strictly english ascii characters if char ~>=~ 'a' , char ~<=~ 'z' soundex = char; last_symbol = symbol; end if; elsif last_symbol != symbol soundex = soundex || symbol; last_symbol = symbol; end if; end loop; return soundex; end; $$;
i'm using http://www.elephantsql.com/ database host. when connected databse via psql , ran same command, got message: "error: must owner of function soundex".
two questions: error matter? i'm not postgresql expert, believe function exists, maybe doesn't matter if joomla creates different version of it? did cause installation abort though. secondly, if issue, fixes?
Comments
Post a Comment