[Tile-serving] [osm2pgsql] middle-pgsql fails to escape special characters (#247)

[Matt Amos]

I think libpqxx is a really good library. There are some issues around the escaping there as well (IIRC it doesn't natively support hstore, we'd have to add that), and I don't remember whether it allocates while escaping as well...

As for `escape_tag()` - I can't immediately see the problem with it. It seems to add one (or two, if `escape` is set - but I have no idea when that would be set) backslash in front of ", \, \n, \r, \t - which seems to be what the [documentation](http://www.postgresql.org/docs/9.2/static/sql-copy.html#AEN66683) is asking for...

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/247#issuecomment-68783862
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150105/b35f9d8b/attachment.html>