[OSM-dev] [OSM-talk] Trouble in Rangoon

80n 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>
wrote:

> -----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
> concerted
> | 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
> nodes
> * 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)
>
> Marcus
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFHxo1cf1hPnk3Z0cQRAmC9AKDSPxZ8+/S+Ks2TdINaXnRsvEehvwCfUDi9
> EqqcL8Sn+VP1/5fuLWESIeU=
> =u3lY
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080228/cde25bea/attachment.html>


More information about the dev mailing list