Jeff:
> OK, that makes sense. But then what is the error:
>
> Detail: Key (node_id)=(395051992) is not present in
> table "current_nodes".
>
> from? That's what crashed my import. I'm trying to find where
Osmosis
> requests a node_id from current_nodes; or am I misreading the
error?
The fo
OK, that makes sense. But then what is the error:
Detail: Key (node_id)=(395051992) is not present in table "current_nodes".
from? That's what crashed my import. I'm trying to find where Osmosis
requests a node_id from current_nodes; or am I misreading the error?
Thanks,
Jeff
On Fri, Jun 5, 20
Am Freitag, den 05.06.2009, 14:58 -0400 schrieb Jeffrey Warren:
> Detail: Key (node_id)=(395051992) is not present in table
"current_nodes".
The field that is present is actually named node_id and that is the one
that is mentioned.
> ALTER TABLE ONLY current_way_nodes ADD CONSTRAINT
> curren
Warren
Sent: 05 June 2009 19:59
To: Joachim Zobel
Cc: dev Openstreetmap; Josh Levinger
Subject: Re: [OSM-dev] Osmosis error, duplicate
Thanks, I was tracing the original foreign key constraint error
(reproduced in full below) and this line caught my eye:
Detail: Key (node_id)=(395051992
Thanks, I was tracing the original foreign key constraint error (reproduced
in full below) and this line caught my eye:
Detail: Key (node_id)=(395051992) is not present in table "current_nodes".
current_nodes has no node_id column!
The constraint is created in the latest pgsql schema, here:
(
Am Freitag, den 05.06.2009, 12:40 -0400 schrieb Jeffrey Warren:
> and it's been running the following query for about 24 hours:
>
> SELECT Count(*) AS changesetCount FROM changesets WHERE id=$1
Take a look on Brets pgsql-latest.sql script (after the COPYs) and add
the index on id:
ALTER TABLE
I've been importing with:
motel:osmosis-0.31 eco$ bin/osmosis --read-xml-0.6
file="/Volumes/Planet/planet.osm" --write-apidb-0.6
populateCurrentTables=yes host="localhost" database="" user=""
password="" validateSchemaVersion=no
and it's been running the following query for about 24 ho
Am Dienstag, den 02.06.2009, 11:52 -0700 schrieb Jeffrey Warren:
> I was importing a planet dump to pgsql with the --write-apidb-0.6 and
> got the error:
>
> ERROR: insert or update on table "current_way_nodes" violates foreign
> key constraint "current_way_nodes_node_id_fkey" Detail: Key
> (no
I was importing a planet dump to pgsql with the --write-apidb-0.6 and got
the error:
ERROR: insert or update on table "current_way_nodes" violates foreign key
constraint "current_way_nodes_node_id_fkey"
Detail: Key (node_id)=(395051992) is not present in table "current_nodes".
Why would that cau
Maarten Deen wrote:
> I have this (for me) unexplainable error "duplicate entry ... for key 1" when
> trying to load some data into a database with Osmosis (latest, 0.30).
>
> The data is:
>
> xmlns:osmxapi='http://www.informationfreeway.org/osmxapi/0.5'
> osmxapi:uri='/api/0.5/node[amenity=atm
I have this (for me) unexplainable error "duplicate entry ... for key 1" when
trying to load some data into a database with Osmosis (latest, 0.30).
The data is:
and
If I put these in different files, then the second always fails to load with
error "Dup
11 matches
Mail list logo
