Trying to fetch the package file returns 404, because old packages aren’t retained forever. I’m not sure if they’re kept around at all, or deleted the moment a new version is fetched, but so long as you update the sync db, (run pacman -Sy) you have nothing to worry about in that regard.

No, no. You’re supposed to drop tables, not throw them.