[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