Local Nominatim and DB Error: insufficient permissions

rukus · 2011-04-10T21:29:01.000Z

Hi guys, hope someone can help me with the problem of my local nominatim installation. I’ve installed nominatim as described in wiki but after all when i’m trying to search some address it will return long trace that i can’t figure out what to do with it. It’s long but i think it should be posted as is to provide more info to you.

PS: looks like its permission problem but i don’t know how to fix it - i’ve created user as mentioned in wiki and didn’t change connection string.

string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” object(DB_Error)#2 (8) { [“error_message_prefix”]=> string(0) “” [“mode”]=> int(1) [“level”]=> int(1024) [“code”]=> int(-26) [“message”]=> string(34) “DB Error: insufficient permissions” [“userinfo”]=> string(2231) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC [nativecode=ERROR: permission denied for relation country_name CONTEXT: SQL statement “select get_name_by_language(country_name.name, $1 ) as name from placex join country_name using (country_code) where place_id = $2 limit 1” PL/pgSQL function “get_address_by_language” line 50 at SQL statement]” [“backtrace”]=> array(8) { [0]=> array(6) { [“file”]=> string(21) “/usr/share/php/DB.php” [“line”]=> int(966) [“function”]=> string(10) “PEAR_Error” [“class”]=> string(10) “PEAR_Error” [“type”]=> string(2) “->” [“args”]=> array(5) { [0]=> string(34) “DB Error: insufficient permissions” [1]=> int(-26) [2]=> int(1) [3]=> int(1024) [4]=> string(2231) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC [nativecode=ERROR: permission denied for relation country_name CONTEXT: SQL statement “select get_name_by_language(country_name.name, $1 ) as name from placex join country_name using (country_code) where place_id = $2 limit 1” PL/pgSQL function “get_address_by_language” line 50 at SQL statement]” } } [1]=> array(7) { [“file”]=> string(23) “/usr/share/php/PEAR.php” [“line”]=> int(531) [“function”]=> string(8) “DB_Error” [“class”]=> string(8) “DB_Error” [“object”]=> RECURSION [“type”]=> string(2) “->” [“args”]=> array(4) { [0]=> int(-26) [1]=> int(1) [2]=> int(1024) [3]=> string(2231) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC [nativecode=ERROR: permission denied for relation country_name CONTEXT: SQL statement “select get_name_by_language(country_name.name, $1 ) as name from placex join country_name using (country_code) where place_id = $2 limit 1” PL/pgSQL function “get_address_by_language” line 50 at SQL statement]” } } [2]=> array(7) { [“file”]=> string(28) “/usr/share/php/DB/common.php” [“line”]=> int(1903) [“function”]=> string(10) “raiseError” [“class”]=> string(4) “PEAR” [“object”]=> object(DB_pgsql)#1 (28) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“features”]=> array(7) { [“limit”]=> string(5) “alter” [“new_link”]=> string(5) “4.3.0” [“numrows”]=> bool(true) [“pconnect”]=> bool(true) [“prepare”]=> bool(false) [“ssl”]=> bool(true) [“transactions”]=> bool(true) } [“errorcode_map”]=> array(0) { } [“connection”]=> resource(10) of type (pgsql link) [“dsn”]=> array(9) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“username”]=> string(8) “www-data” [“password”]=> bool(false) [“protocol”]=> string(3) “tcp” [“hostspec”]=> string(0) “” [“port”]=> bool(false) [“socket”]=> bool(false) [“database”]=> string(9) “gazetteer” } [“autocommit”]=> bool(true) [“transaction_opcount”]=> int(0) [“affected”]=> int(0) [“row”]=> array(0) { } [“_num_rows”]=> array(0) { } [“fetchmode”]=> int(2) [“fetchmode_object_class”]=> string(8) “stdClass” [“was_connected”]=> NULL [“last_query”]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” [“options”]=> array(8) { [“result_buffering”]=> int(500) [“persistent”]=> bool(false) [“ssl”]=> bool(false) [“debug”]=> int(0) [“seqname_format”]=> string(6) “%s_seq” [“autofree”]=> bool(false) [“portability”]=> int(0) [“optimize”]=> string(11) “performance” } [“last_parameters”]=> array(0) { } [“prepare_tokens”]=> array(0) { } [“prepare_types”]=> array(0) { } [“prepared_queries”]=> array(0) { } [“_last_query_manip”]=> bool(false) [“_next_query_manip”]=> bool(false) [“_debug”]=> bool(false) [“_default_error_mode”]=> NULL [“_default_error_options”]=> NULL [“_default_error_handler”]=> string(0) “” [“_error_class”]=> string(8) “DB_Error” [“_expected_errors”]=> array(0) { } } [“type”]=> string(2) “->” [“args”]=> array(7) { [0]=> NULL [1]=> int(-26) [2]=> NULL [3]=> NULL [4]=> string(2231) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC [nativecode=ERROR: permission denied for relation country_name CONTEXT: SQL statement “select get_name_by_language(country_name.name, $1 ) as name from placex join country_name using (country_code) where place_id = $2 limit 1” PL/pgSQL function “get_address_by_language” line 50 at SQL statement]” [5]=> string(8) “DB_Error” [6]=> bool(true) } } [3]=> array(7) { [“file”]=> string(27) “/usr/share/php/DB/pgsql.php” [“line”]=> int(790) [“function”]=> string(10) “raiseError” [“class”]=> string(9) “DB_common” [“object”]=> object(DB_pgsql)#1 (28) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“features”]=> array(7) { [“limit”]=> string(5) “alter” [“new_link”]=> string(5) “4.3.0” [“numrows”]=> bool(true) [“pconnect”]=> bool(true) [“prepare”]=> bool(false) [“ssl”]=> bool(true) [“transactions”]=> bool(true) } [“errorcode_map”]=> array(0) { } [“connection”]=> resource(10) of type (pgsql link) [“dsn”]=> array(9) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“username”]=> string(8) “www-data” [“password”]=> bool(false) [“protocol”]=> string(3) “tcp” [“hostspec”]=> string(0) “” [“port”]=> bool(false) [“socket”]=> bool(false) [“database”]=> string(9) “gazetteer” } [“autocommit”]=> bool(true) [“transaction_opcount”]=> int(0) [“affected”]=> int(0) [“row”]=> array(0) { } [“_num_rows”]=> array(0) { } [“fetchmode”]=> int(2) [“fetchmode_object_class”]=> string(8) “stdClass” [“was_connected”]=> NULL [“last_query”]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” [“options”]=> array(8) { [“result_buffering”]=> int(500) [“persistent”]=> bool(false) [“ssl”]=> bool(false) [“debug”]=> int(0) [“seqname_format”]=> string(6) “%s_seq” [“autofree”]=> bool(false) [“portability”]=> int(0) [“optimize”]=> string(11) “performance” } [“last_parameters”]=> array(0) { } [“prepare_tokens”]=> array(0) { } [“prepare_types”]=> array(0) { } [“prepared_queries”]=> array(0) { } [“_last_query_manip”]=> bool(false) [“_next_query_manip”]=> bool(false) [“_debug”]=> bool(false) [“_default_error_mode”]=> NULL [“_default_error_options”]=> NULL [“_default_error_handler”]=> string(0) “” [“_error_class”]=> string(8) “DB_Error” [“_expected_errors”]=> array(0) { } } [“type”]=> string(2) “->” [“args”]=> array(5) { [0]=> int(-26) [1]=> NULL [2]=> NULL [3]=> NULL [4]=> string(287) “ERROR: permission denied for relation country_name CONTEXT: SQL statement “select get_name_by_language(country_name.name, $1 ) as name from placex join country_name using (country_code) where place_id = $2 limit 1” PL/pgSQL function “get_address_by_language” line 50 at SQL statement” } } [4]=> array(7) { [“file”]=> string(27) “/usr/share/php/DB/pgsql.php” [“line”]=> int(337) [“function”]=> string(15) “pgsqlRaiseError” [“class”]=> string(8) “DB_pgsql” [“object”]=> object(DB_pgsql)#1 (28) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“features”]=> array(7) { [“limit”]=> string(5) “alter” [“new_link”]=> string(5) “4.3.0” [“numrows”]=> bool(true) [“pconnect”]=> bool(true) [“prepare”]=> bool(false) [“ssl”]=> bool(true) [“transactions”]=> bool(true) } [“errorcode_map”]=> array(0) { } [“connection”]=> resource(10) of type (pgsql link) [“dsn”]=> array(9) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“username”]=> string(8) “www-data” [“password”]=> bool(false) [“protocol”]=> string(3) “tcp” [“hostspec”]=> string(0) “” [“port”]=> bool(false) [“socket”]=> bool(false) [“database”]=> string(9) “gazetteer” } [“autocommit”]=> bool(true) [“transaction_opcount”]=> int(0) [“affected”]=> int(0) [“row”]=> array(0) { } [“_num_rows”]=> array(0) { } [“fetchmode”]=> int(2) [“fetchmode_object_class”]=> string(8) “stdClass” [“was_connected”]=> NULL [“last_query”]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” [“options”]=> array(8) { [“result_buffering”]=> int(500) [“persistent”]=> bool(false) [“ssl”]=> bool(false) [“debug”]=> int(0) [“seqname_format”]=> string(6) “%s_seq” [“autofree”]=> bool(false) [“portability”]=> int(0) [“optimize”]=> string(11) “performance” } [“last_parameters”]=> array(0) { } [“prepare_tokens”]=> array(0) { } [“prepare_types”]=> array(0) { } [“prepared_queries”]=> array(0) { } [“_last_query_manip”]=> bool(false) [“_next_query_manip”]=> bool(false) [“_debug”]=> bool(false) [“_default_error_mode”]=> NULL [“_default_error_options”]=> NULL [“_default_error_handler”]=> string(0) “” [“_error_class”]=> string(8) “DB_Error” [“_expected_errors”]=> array(0) { } } [“type”]=> string(2) “->” [“args”]=> array(0) { } } [5]=> array(7) { [“file”]=> string(28) “/usr/share/php/DB/common.php” [“line”]=> int(1216) [“function”]=> string(11) “simpleQuery” [“class”]=> string(8) “DB_pgsql” [“object”]=> object(DB_pgsql)#1 (28) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“features”]=> array(7) { [“limit”]=> string(5) “alter” [“new_link”]=> string(5) “4.3.0” [“numrows”]=> bool(true) [“pconnect”]=> bool(true) [“prepare”]=> bool(false) [“ssl”]=> bool(true) [“transactions”]=> bool(true) } [“errorcode_map”]=> array(0) { } [“connection”]=> resource(10) of type (pgsql link) [“dsn”]=> array(9) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“username”]=> string(8) “www-data” [“password”]=> bool(false) [“protocol”]=> string(3) “tcp” [“hostspec”]=> string(0) “” [“port”]=> bool(false) [“socket”]=> bool(false) [“database”]=> string(9) “gazetteer” } [“autocommit”]=> bool(true) [“transaction_opcount”]=> int(0) [“affected”]=> int(0) [“row”]=> array(0) { } [“_num_rows”]=> array(0) { } [“fetchmode”]=> int(2) [“fetchmode_object_class”]=> string(8) “stdClass” [“was_connected”]=> NULL [“last_query”]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” [“options”]=> array(8) { [“result_buffering”]=> int(500) [“persistent”]=> bool(false) [“ssl”]=> bool(false) [“debug”]=> int(0) [“seqname_format”]=> string(6) “%s_seq” [“autofree”]=> bool(false) [“portability”]=> int(0) [“optimize”]=> string(11) “performance” } [“last_parameters”]=> array(0) { } [“prepare_tokens”]=> array(0) { } [“prepare_types”]=> array(0) { } [“prepared_queries”]=> array(0) { } [“_last_query_manip”]=> bool(false) [“_next_query_manip”]=> bool(false) [“_debug”]=> bool(false) [“_default_error_mode”]=> NULL [“_default_error_options”]=> NULL [“_default_error_handler”]=> string(0) “” [“_error_class”]=> string(8) “DB_Error” [“_expected_errors”]=> array(0) { } } [“type”]=> string(2) “->” [“args”]=> array(1) { [0]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” } } [6]=> array(7) { [“file”]=> string(28) “/usr/share/php/DB/common.php” [“line”]=> int(1663) [“function”]=> string(5) “query” [“class”]=> string(9) “DB_common” [“object”]=> object(DB_pgsql)#1 (28) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“features”]=> array(7) { [“limit”]=> string(5) “alter” [“new_link”]=> string(5) “4.3.0” [“numrows”]=> bool(true) [“pconnect”]=> bool(true) [“prepare”]=> bool(false) [“ssl”]=> bool(true) [“transactions”]=> bool(true) } [“errorcode_map”]=> array(0) { } [“connection”]=> resource(10) of type (pgsql link) [“dsn”]=> array(9) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“username”]=> string(8) “www-data” [“password”]=> bool(false) [“protocol”]=> string(3) “tcp” [“hostspec”]=> string(0) “” [“port”]=> bool(false) [“socket”]=> bool(false) [“database”]=> string(9) “gazetteer” } [“autocommit”]=> bool(true) [“transaction_opcount”]=> int(0) [“affected”]=> int(0) [“row”]=> array(0) { } [“_num_rows”]=> array(0) { } [“fetchmode”]=> int(2) [“fetchmode_object_class”]=> string(8) “stdClass” [“was_connected”]=> NULL [“last_query”]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” [“options”]=> array(8) { [“result_buffering”]=> int(500) [“persistent”]=> bool(false) [“ssl”]=> bool(false) [“debug”]=> int(0) [“seqname_format”]=> string(6) “%s_seq” [“autofree”]=> bool(false) [“portability”]=> int(0) [“optimize”]=> string(11) “performance” } [“last_parameters”]=> array(0) { } [“prepare_tokens”]=> array(0) { } [“prepare_types”]=> array(0) { } [“prepared_queries”]=> array(0) { } [“_last_query_manip”]=> bool(false) [“_next_query_manip”]=> bool(false) [“_debug”]=> bool(false) [“_default_error_mode”]=> NULL [“_default_error_options”]=> NULL [“_default_error_handler”]=> string(0) “” [“_error_class”]=> string(8) “DB_Error” [“_expected_errors”]=> array(0) { } } [“type”]=> string(2) “->” [“args”]=> array(1) { [0]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” } } [7]=> array(7) { [“file”]=> string(33) “/home/seth/public_html/search.php” [“line”]=> int(645) [“function”]=> string(6) “getAll” [“class”]=> string(9) “DB_common” [“object”]=> object(DB_pgsql)#1 (28) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“features”]=> array(7) { [“limit”]=> string(5) “alter” [“new_link”]=> string(5) “4.3.0” [“numrows”]=> bool(true) [“pconnect”]=> bool(true) [“prepare”]=> bool(false) [“ssl”]=> bool(true) [“transactions”]=> bool(true) } [“errorcode_map”]=> array(0) { } [“connection”]=> resource(10) of type (pgsql link) [“dsn”]=> array(9) { [“phptype”]=> string(5) “pgsql” [“dbsyntax”]=> string(5) “pgsql” [“username”]=> string(8) “www-data” [“password”]=> bool(false) [“protocol”]=> string(3) “tcp” [“hostspec”]=> string(0) “” [“port”]=> bool(false) [“socket”]=> bool(false) [“database”]=> string(9) “gazetteer” } [“autocommit”]=> bool(true) [“transaction_opcount”]=> int(0) [“affected”]=> int(0) [“row”]=> array(0) { } [“_num_rows”]=> array(0) { } [“fetchmode”]=> int(2) [“fetchmode_object_class”]=> string(8) “stdClass” [“was_connected”]=> NULL [“last_query”]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” [“options”]=> array(8) { [“result_buffering”]=> int(500) [“persistent”]=> bool(false) [“ssl”]=> bool(false) [“debug”]=> int(0) [“seqname_format”]=> string(6) “%s_seq” [“autofree”]=> bool(false) [“portability”]=> int(0) [“optimize”]=> string(11) “performance” } [“last_parameters”]=> array(0) { } [“prepare_tokens”]=> array(0) { } [“prepare_types”]=> array(0) { } [“prepared_queries”]=> array(0) { } [“_last_query_manip”]=> bool(false) [“_next_query_manip”]=> bool(false) [“_debug”]=> bool(false) [“_default_error_mode”]=> NULL [“_default_error_options”]=> NULL [“_default_error_handler”]=> string(0) “” [“_error_class”]=> string(8) “DB_Error” [“_expected_errors”]=> array(0) { } } [“type”]=> string(2) “->” [“args”]=> array(1) { [0]=> string(1930) “select osm_type,osm_id,class,type,rank_search,rank_address,min(place_id) as place_id,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as langaddress,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) as placename,get_name_by_language(name, ARRAY[‘ref’]) as ref,avg(ST_X(ST_Centroid(geometry))) as lon,avg(ST_Y(ST_Centroid(geometry))) as lat from placex where place_id in (38300) group by osm_type,osm_id,class,type,rank_search,rank_address,country_code,get_address_by_language(place_id, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘short_name:uk’,‘short_name:ru’,‘short_name:en-us’,‘short_name:en’,‘name:uk’,‘name:ru’,‘name:en-us’,‘name:en’,‘place_name:uk’,‘place_name:ru’,‘place_name:en-us’,‘place_name:en’,‘official_name:uk’,‘official_name:ru’,‘official_name:en-us’,‘official_name:en’,‘short_name’,‘name’,‘place_name’,‘official_name’,‘ref’,‘type’]) ,get_name_by_language(name, ARRAY[‘ref’]) order by rank_search,rank_address,CASE when min(place_id) = 38300 then 0 ELSE 10000000 END ASC” } } } [“callback”]=> NULL }

rukus · 2011-04-14T12:24:28.000Z

Fixed this one

sudo su postgres
psql -d gazetteer
GRANT ALL PRIVILEGES ON country_name TO PUBLIC;