Created
January 9, 2020 11:34
-
-
Save adamruzicka/b6b19d08e2bdce828fa3ca22eda97fb6 to your computer and use it in GitHub Desktop.
Removing undeliverable dynflow envelopes
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Delete all undeliverable envelopes | |
-- | |
DELETE FROM dynflow_envelopes | |
WHERE receiver_id NOT IN (SELECT id FROM dynflow_coordinator_records); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment