[OSM-dev] Osmosis and Postgresql

[Richard Fairhurst]

Jeffrey Warren wrote:
> I'm still not done right now (i've been pinging the list here 
> occasionally) and my latest problem is that I'm getting several 
> errors like the following:
> ERROR:  insert or update on table "current_way_nodes" violates 
> foreign key constraint "current_way_nodes_node_id_fkey"

I get another constraint throwing an error whenever I try to write to the
db:

ERROR:  duplicate key value violates unique constraint "current_nodes_pkey1"
: INSERT INTO "current_nodes" ("visible", "timestamp", "latitude",
"changeset_id", "tile", "version", "longitude") VALUES('t', '2009-07-08
08:03:12.084512', 530909508, 5283, 2062370947, 1, -25840092) RETURNING "id"

Slightly oddly, I also find that when I create a new user, it has id 1,
whereas I'd have expected it to be maximum user id plus one.

Any clues?

cheers
Richard
-- 
View this message in context: http://www.nabble.com/Osmosis-and-Postgresql-tp24119199p24387254.html
Sent from the OpenStreetMap - Dev mailing list archive at Nabble.com.