Postgres Error on Installation - Joomla! Forum - community, help and support


on installing postgresql database, encountered following error:

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

Popular posts from this blog

Joomla 3.3 Installation Error message - Joomla! Forum - community, help and support

Multilanguage infinite redirect loop error. - Joomla! Forum - community, help and support

trim media limit reached