[OSM-dev] osm2pgsql / diff / upercase tag
Jon Burgess
jburgess777 at googlemail.com
Tue Oct 27 19:31:47 GMT 2009
On Tue, 2009-10-27 at 14:01 +0100, sly (sylvain letuffe) wrote:
> Hi,
>
> Maybe this case is known (also a google search didn't pointed me to it) but
> osm2pgsql diff adding mode fails when there is a tag with upercase caracters
...
> Adding new column "IN" to "planet_osm_point"
> ALTER TABLE planet_osm_point ADD COLUMN "IN" text;
> failed: ERROR: column "IN" of relation "planet_osm_point" already exists
>
> Error occurred, cleaning up
Fixed in r18316. We need to add double quotes around the column name
when calling PQfnumber() otherwise postgresql will convert it to lower
case.
Jon
More information about the dev
mailing list