[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