Comment 2 for bug 299968

Revision history for this message
Jeroen T. Vermeulen (jtv) wrote :

The SQL to do this all in one go would be:

UPDATE TranslationMessage
SET potemplate = NULL
FROM POTMsgSet
WHERE
    POTMsgSet.id = TranslationMessage.potmsgset AND
    POTMsgSet.potemplate <> TranslationMessage.potemplate;