[Monotone-devel] deleting erroneous cert

[Stephen Leake]

We accidently added a bad branch cert to a revision; now it's on two
unreleated branches, and there's no way to recover short of editing
the database directly to remove the cert.

Here's the offending cert:

address@hidden mtn -d gds.db ls certs 516e1b7b2df2e1820f4a11060ac5fa7b8ea65d72
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : author
Value : address@hidden
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : branch
Value : gpm.work_gpm_release
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : branch
Value : lro.main
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : branch
Value : lro.work_gpm_release
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : branch
Value : lro.work_steve
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : changelog
Value : propagate from branch 'lro.work_release_pde_fix' (head 
49591b0e4fc859618a32fb857c8b08baaf213620)
      :             to branch 'lro.main' (head 
fb2f3a3d23755757fa98d5957fa993d82e80b425)
--------------------------------------------------------------------------------
Key   : address@hidden
Sig   : ok
Name  : date
Value : 2009-01-15T14:31:36


the branch cert with "gpm" in it is the bad cert.

I'm trying to write the SQL statement to do the deletion. I tried:

mtn -d gds.db db execute "delete from revision_certs where
id=\"516e1b7b2df2e1820f4a11060ac5fa7b8ea65d72\" and name=\"branch\"
and value=\"gpm.work_gpm_release\""

but that gives a result of '0 rows'. My SQL is _very_ rusty; help!

-- 
-- Stephe