What if we say it's not a bug, but a feature. Will it break some contracts with user or some functionality?
An important thing to note here. We have to trade off an opportunity to significantly improve temp tables performance by removing locks for a "not a bug, but a feature". This seems odd to me. Arguably, the number of people who need faster temp relations is greater than the number of people who want to have access to temp relations of other backends.