Pleroma : unable to send public toots

My poor little Pleroma instance wasn't able to send nasty public toots. To fix it I had to do some black magic in the postgres database.