-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tom Hughes schrieb: | In message <[EMAIL PROTECTED]> | Marcus Wolschon <[EMAIL PROTECTED]> wrote: | |> In the end we really need something like |> the history-tab in wikipedia without breaking |> referential integrity uppon restores. Once |> accidents and vandalism becomes more common |> there is not much of a way around that. | | That's basically not possible - we can't even maintain proper | referential integrity on ordinary uploads so how you expect to | maintain it through a bulk restore is beyond me.
We do not check that * uploaded way_nodes have existing nodes * uploaded relations have existing items * removed ways have no way_nodes anymore * removed nodes have not way_nodes or relations anymore? Why not? The client is responsible for not uploading crap. If it does, it should get en error-message and the (remainder of the) upload not be commited. | For example you can do: | | SELECT * | FROM nodes | WHERE tile IN (...) AND timestamp <= ... | | but that will get you all versions of each node that predate | the given timestamp. Which might be a lot more data than you | want. SELECT *, MAX(version) ~ FROM nodes ~ WHERE tile IN (...) ~ AND timestamp <= XYZ ~ group by node_id Marcus -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHxq1af1hPnk3Z0cQRAuvbAJoDVcYaRQU0QkdnNK/0aZjv/j0VdQCfSf5A RzFBeCc31xMBEw9/KPFhHbA= =XcHT -----END PGP SIGNATURE----- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
