Re: [Monotone-devel] deleting erroneous cert

[Derek Scherger]

On Tue, Feb 3, 2009 at 8:58 AM, Stephen Leake <address@hidden> wrote:

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!

Try with hex(id) = '516...' (id's are now binary values). 

Also, you may want to try a select first and ensure that it returns the correct rows before running the delete.

Cheers,
Derek