[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