Up here the product you want is called tuck tape. It's red.
Amazon.com: tuck tape
It's ultra sticky and doesn't really let go unless it gets very hot or wet. I used some to patch leaks in my kids slip and slide hose over the summer. It held up to the pressure for a couple of months.