You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.
Reporter: medi[at]milaro.net [Submitted to the original trac issue database at 8.44am, Friday, 17th September 2010]
hi,
afer a large mass import from the history data have i follow limit
insert_rel failed: ERROR: value "69304" is out of range for type smallint
at daten/2009/1111-1112.osc.gz
error msg:
insert_rel failed: ERROR: value "69304" is out of range for type smallint
(7)
Arguments were: 7432, 0, 69304, {38163187,38163191,....
{"type","boundary","ref","44","name","Loire-Atlantique","converted_by","Editop_2_OSM_v0016","boundary","administrative","admin_level","6"},
Error occurred, cleaning up
problem is the smallint from planet_osm_rels.rel_off and the shema in middle-pgsql.c
i add as atachment a smal diff for fixing the limit
ps: please add a auto change typ for existing tables ;)
The text was updated successfully, but these errors were encountered:
Author: jburgess777[at]googlemail.com [Added to the original trac issue at 8.51pm, Friday, 17th September 2010]
At the moment that particular relation has the following set:
gis=# select id,way_off,rel_off from planet_osm_rels where id=7432;
id | way_off | rel_off
------+---------+---------
7432 | 0 | 190
I think that particular version you are referring to was quickly reverted or cleaned up. The change should only be needed it a relation has more than 65536 members. I don't think any of the current data needs this.
I'm a little reluctant to add this at the moment, especially because it needs a tweak of the DB schema. I guess you can work with your own patched version at the moment. In the short term, I might be more interested in adding a sanity check which rejects this data.
Reporter: medi[at]milaro.net
[Submitted to the original trac issue database at 8.44am, Friday, 17th September 2010]
hi,
afer a large mass import from the history data have i follow limit
insert_rel failed: ERROR: value "69304" is out of range for type smallint
at daten/2009/1111-1112.osc.gz
error msg:
insert_rel failed: ERROR: value "69304" is out of range for type smallint
(7)
Arguments were: 7432, 0, 69304, {38163187,38163191,....
{"type","boundary","ref","44","name","Loire-Atlantique","converted_by","Editop_2_OSM_v0016","boundary","administrative","admin_level","6"},
Error occurred, cleaning up
problem is the smallint from planet_osm_rels.rel_off and the shema in middle-pgsql.c
i add as atachment a smal diff for fixing the limit
ps: please add a auto change typ for existing tables ;)
The text was updated successfully, but these errors were encountered: