In one transaction, add (101, 'keep') to jobs, then set a savepoint and add (102, 'drop'). Roll back only the second insert to that point and finish the transaction so that only (101, 'keep') remains in jobs.