Oh man! A foley should not hurt like that. Persoanlly I don’t know if I’d could wait 2 days. But if you are decided I’d keep drinking water to try to clear things out. Resist the temptation to not drink. The standard therapy is drink, walk, drink, walk. But you’ve got something else going on here.