No, the data is not corrupt, nor are there duplicate entries. Quite a few current_way_nodes are not getting deleted when they cease to be 'current', that is, once they're only history and no longer part of the current planet. I asked earlier about what mechanism actually deletes current_way_nodes if marked for deletion (i think the tag is 'visible=false' but i might be mistaken) but nobody seemed to know - it seems the best route is to go through and delete those orphans, but I couldn't write a single SQL query to do so efficiently and before writing a script to do it, I realized that the rails port doesn't really care if they're there, or if the constraint is created.
Jeff On Tue, Jul 7, 2009 at 3:24 PM, Shaun McDonald <[email protected]>wrote: > > On 7 Jul 2009, at 18:47, Joachim Zobel wrote: > > > Am Mittwoch, den 01.07.2009, 09:47 +1000 schrieb Brett Henderson: > >> Jeffrey Warren wrote: > >>> And along those lines, should we remove the foreign key constraints > >>> from the schema, Brett, if they're not necessary and they cause > >>> Osmosis imports to fail? > >> I don't mind really. I only make them available as a convenience so > >> people don't need to run the rails migrations themselves. I don't > >> want > >> to put much effort into maintaining them so I just leave them as is. > >> Is > >> this something you'd be interested in looking after? > > > > I am somewhat confused, maybe I missed something. Either you can > > recreate the constraint if the import is done or the data is > > _corrupt_. > > > > If you are loading a larger volume of data you probably want to drop > > _all_ constraints and indexes before that, recreate some in the middle > > and the rest afterwards. > > > > Could it be that your constraint failures are due to a node/way/ > relation containing two keys that have different capitalisation? > > Shaun > > > > _______________________________________________ > dev mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/dev >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
