But are there any reasons to allow us to DROP such tables?
Hi!
This topic has already been discussed in [0], I believe. I'm not sure how it all ended and if there were any changes made in the end. But from the user's perspective, temporary tables are expected to be isolated within sessions, I think. This is an ideal solution, but does it feasible or not is a question.
BTW, if we can "isolate" temp relations, we'll be one step close to get rid of temp relations locking [1].