pgstorage: Empty temp tables instead of dropping them
Similarly to what we do in the swh.storage.
Related to D2580