[OSM-dev] Osmosis and Postgresql
Richard Fairhurst
richard at systemed.net
Wed Jul 8 09:10:12 BST 2009
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.
More information about the dev
mailing list