[OSM-dev] [OSM-talk] Trouble in Rangoon
80n80n at gmail.com
Thu Feb 28 10:51:19 GMT 2008
On Thu, Feb 28, 2008 at 10:30 AM, Marcus Wolschon <marcus at wolschon.biz>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Andy Robinson (blackadder) schrieb:
> |> The need for area-level revert is known and understood, we just never
> |> have enough programmers to do all the funky things that need doing...
> | Indeed, though to help the original user out perhaps we can have a
> | effort to get any deleted data returned. needs someone with a bit of
> time to
> | investigate properly. Have therefore copied to dev.
> Sounds like we could need a stored procedure to undelete everything a
> ~ given user deleted between 2 given timestamps.
In this case, unless its accidental, it would be wise to revert *all* edits
by the user responsible.
> What does our table-structure look like?
> I am thinking of something like:
> * undelete all nodes
> * then select all deleted ways where all their way_nodes have existing
> * undelete all way_nodes of these ways
> * undelete all these ways
> * 3x select all deleted relations where all their nodes, ways and
> ~ relations exist and undelete them
> (done 3x to support relations relating to relations. We do not have
> ~ [possibly infinite] loops or recursion in stored procedures)
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> -----END PGP SIGNATURE-----
> dev mailing list
> dev at openstreetmap.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev