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"');
Note:
See TracTickets
for help on using tickets.
This was a duplicate of #5160 and already fixed in the latest trunk. Thanks rouault.