Opened 7 years ago

Closed 7 years ago

#4332 closed defect (fixed)

Nominatim: Unable to create some database functions

Reported by: Xeno22 Owned by: geocoding@…
Priority: minor Milestone:
Component: nominatim Version:
Keywords: Cc:

Description

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?

Change History (1)

comment:1 Changed 7 years ago by Sarah Hoffmann

Resolution: fixed
Status: newclosed

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

Note: See TracTickets for help on using tickets.