[OSM-dev] [OSM-talk] problem inserting nodes through the OSM API

IgnacioZ zignacio at gmail.com
Mon May 3 23:27:49 BST 2010

Hi I'm a bit lost here. For me this looks like a bug: it's trying to insert
a tuple that represents the tag of a node before inserting the node (at
least that looks like).

I would like to know if there is a workaround, or where should I report the

If you need some help fixing it, let me know. Who maintains the


Here I copy the error again:

ActiveRecord::StatementInvalid: PGError: ERROR:  insert or update on table
"current_node_tags" violates foreign key constraint
DETAIL:  Key (id)=(717587768) is not present in table "current_nodes".
: INSERT INTO "current_node_tags" ("k", "v", "id") VALUES(E'name',
E'Caseratto', 717587768) RETURNING "id"

On Sun, May 2, 2010 at 4:53 PM, IgnacioZ <zignacio at gmail.com> wrote:

> Hi I'm using real data for "testing" and I'm uploading the data to
> production. Then I check it with Potlach and it's working fine for most
> nodes, but sometimes I get the errors I mentioned (during the upload) and
> then the nodes are not in the database.
> These are three examples of XML that had the error:
> <osm><node changeset="4588121" lat="-31.427919" lon="-64.187429"><tag
> k="name" v="Caseratto"/><tag k="amenity" v="bar"/></node></osm>
> <osm><node changeset="4588121" lat="-31.428072" lon="-64.187143"><tag
> k="name" v="Palestra"/><tag k="type" v="climbing"/></node></osm>
> <osm><node changeset="4588121" lat="-31.428261" lon="-64.186582"><tag
> k="name" v="Beto's"/><tag k="amenity" v="fast_food"/></node></osm>
> If you check out that changeset you will find that there are other nodes
> that were uploaded without problems.
> Thanks,
> Ignacio.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100503/12c0d186/attachment.html>

More information about the dev mailing list