[OSM-talk] Osm2pgsql and column names with two underscores

[Martijn van Oosterhout]

On Mon, Mar 30, 2009 at 2:08 PM, Jukka Rahkonen
<jukka.rahkonen at mmmtike.fi> wrote:
> Hi,
>
> An osm2pgsql user writes on the forum about importing special tags
> into PostGIS.
> He has defined for example these tags:
> node       openGeoDB:telephone_area_code       text
> node       openGeoDB:license_plate_code          text
>
> Import fails and error message is:
> CREATE TABLE planet_osm_point ( osm_id int4,"access" text,
> "admin_level" text,

Ok, it's got nothing to do with the underscores and more to do with
the fact that the field names are limited to 23 characters by
osm2pgsql. I don't really know where this restriction comes from, does
anyone else have ideas?

It should be easy to fix in output-pgsql.c. Fix the read_style_file()
function to increase the length of the buffers.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/