edited indices an setup file to grant select for table country_osm_grid

[nominatim.git] / lib / db.php

diff --git a/lib/db.php b/lib/db.php
index 145c57d0b09847b1491bdfe5d72612d6ad192376..493d25f5f8860c489d81e2b8a2c6b8d53fd65933 100644 (file)
--- a/lib/db.php
+++ b/lib/db.php
@@ -8,7 +8,7 @@ function &getDB($bNew = false, $bPersistent = false)
     // Get the database object
     $oDB = chksql(
         DB::connect(CONST_Database_DSN.($bNew?'?new_link=true':''), $bPersistent),
     // Get the database object
     $oDB = chksql(
         DB::connect(CONST_Database_DSN.($bNew?'?new_link=true':''), $bPersistent),

-        "Failed to establish database connection"
+        'Failed to establish database connection'

     );
     $oDB->setFetchMode(DB_FETCHMODE_ASSOC);
     $oDB->query("SET DateStyle TO 'sql,european'");
     );
     $oDB->setFetchMode(DB_FETCHMODE_ASSOC);
     $oDB->query("SET DateStyle TO 'sql,european'");


@@ -23,6 +23,11 @@ function getDBQuoted($s)
     return "'".pg_escape_string($s)."'";
 }
 
     return "'".pg_escape_string($s)."'";
 }
 

+function getArraySQL($a)
+{
+    return 'ARRAY['.join(',', $a).']';
+}
+

 function getPostgresVersion(&$oDB)
 {
     $sVersionString = $oDB->getOne('select version()');
 function getPostgresVersion(&$oDB)
 {
     $sVersionString = $oDB->getOne('select version()');