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

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Mon Mar 30 13:08:11 BST 2009


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, 

---SNIP---
"openGeoDB:postal_codes" text,"openGeoDB:telephone_are" a_code,
"openGeoDB:type" text,"openGeoDB:license_plate" _code,"z_order"
int4 );

failed: ERROR:  type "a_code" does not exist
LINE 1: ...eoDB:postal_codes" text,
"openGeoDB:telephone_are" a_code,"op...
                                                             ^

Error occurred, cleaning up

Look at these:
"openGeoDB:telephone_are" a_code,
"openGeoDB:license_plate" _code

It looks like column name gets truncated at the second 
underline character. Could it be some bug in osm2pgsql,
or is it some other place where the error occurs?

-Jukka Rahkonen-






More information about the talk mailing list