[OSM-dev] Importing planet file with osmosis into PostgreSQL

[Shaun McDonald]

On 13 Dec 2009, at 10:47, Lennard wrote:

> Frederik Ramm wrote:
> 
>> The planet files do not have referential integrity. Because the ways are 
>> dumped long after the nodes, if someone creates a new way plus new nodes 
>> some time during the planet dump creation, the new way will be in the 
>> dump but the new nodes will not.
> 
> I thought that was fixed, and the dump now runs in a transaction?
> 

It is using a transaction, however a locking transaction (which would be needed for this) reduces performance too much thus isn't done.

> It would thus more likely point to data that is in fact incomplete in 
> the OSM db itself?

Nope.

More information is available on 
http://wiki.openstreetmap.org/wiki/Planet.osm/FAQ
and
http://wiki.openstreetmap.org/wiki/Planet.osm

Shaun