[OSM-dev] [OSM-talk] Trouble in Rangoon
Marcus Wolschon
marcus at wolschon.biz
Thu Feb 28 10:30:52 GMT 2008
-----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.
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-----
More information about the dev
mailing list