[Geocoding] [OpenStreetMap] #4332: Nominatim: Unable to create some database functions

OpenStreetMap trac at openstreetmap.org
Thu Mar 29 13:41:24 BST 2012


#4332: Nominatim: Unable to create some database functions
-----------------------+----------------------------------------------------
 Reporter:  Xeno22     |       Owner:  geocoding@…                
     Type:  defect     |      Status:  new                        
 Priority:  minor      |   Milestone:                             
Component:  nominatim  |     Version:                             
 Keywords:             |  
-----------------------+----------------------------------------------------
 I get this on './utils/setup.php --create-functions':

 ERROR:  syntax error at or near "$1"
 LINE 1: insert into location_property_tiger (place_id,  $1 ,  $2 , h...
                                                         ^
 QUERY:  insert into location_property_tiger (place_id,  $1 ,  $2 ,
 housenumber, postcode, centroid) values (nextval('seq_place'),  $1 ,  $2 ,
 $3 ,  $4 , ST_Line_Interpolate_Point( $5 , ( $3 ::float- $6 ::float)/ $7
 ::float))
 CONTEXT:  SQL statement in PL/PgSQL function "tigger_create_interpolation"
 near line 75
 ERROR:  syntax error at or near "$1"
 LINE 1: insert into location_property_aux (place_id,  $1 , parent_pl...
                                                       ^
 QUERY:  insert into location_property_aux (place_id,  $1 ,
 parent_place_id, housenumber, postcode, centroid) values
 (nextval('seq_place'),  $1 ,  $2 ,  $3 ,  $4 ,  $5 )
 CONTEXT:  SQL statement in PL/PgSQL function "aux_create_property" near
 line 40


 Using postgres 8.4 on ubuntu and Nominatim from git.

 Any idea?

-- 
Ticket URL: <https://trac.openstreetmap.org/ticket/4332>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world



More information about the Geocoding mailing list