Opened 11 years ago

Closed 11 years ago

#5165 closed defect (duplicate)

Escaping problems from OSM to PGDump using hstore

Reported by: ingenieroariel Owned by: warmerdam
Priority: normal Milestone: 1.10.1
Component: default Version: svn-trunk
Severity: normal Keywords:
Cc:

Description

When loading points from the OSM planet file in PBF format, the generated SQL is rejected by Postgres with the following message:

psql:buildings_points.sql:3328: ERROR:  Syntax error near 'A' at position 25
LINE 1: ...7FB7224840', '255877812', 'Apotheke Bindermichl', '"alt_name...

The line that triggers the error is:

INSERT INTO "public"."points" ("wkb_geometry" , "osm_id", "name", "other_tags") VALUES ('0101000020E6100000035E0B1FB6952C4031AE5D7FB7224840', '255877812', 'Apotheke Bindermichl', '"alt_name"=>"Apotheke \\"Am Bindermichl\\"","amenity"=>"pharmacy","building"=>"entrance","contact:phone"=>"+43 732 341476","dispensing"=>"yes","opening_hours"=>"Mo-Fr 08:00-12:00,14:00-18:00; Sa 08:00-12:00","operator"=>"Mag. pharm. Geraldine Syrowatka"');

Change History (1)

comment:1 by ingenieroariel, 11 years ago

Resolution: duplicate
Status: newclosed

This was a duplicate of #5160 and already fixed in the latest trunk. Thanks rouault.

Note: See TracTickets for help on using tickets.