Skip to content
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.

Nominatim: Unable to create some database functions #4332

Closed
openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment
Closed

Nominatim: Unable to create some database functions #4332

openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment

Comments

@openstreetmap-trac
Copy link

Reporter: Xeno22
[Submitted to the original trac issue database at 5.59pm, Wednesday, 28th March 2012]

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?

@openstreetmap-trac
Copy link
Author

Author: lonvia
[Added to the original trac issue at 9.51pm, Thursday, 29th March 2012]

Issue of variable names vs. table column names. Fixed.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant