I noticed that TRUNCATE and ALTER commands on temporary tables of other sessions produce an error "cannot truncate/alter temporary tables of other sessions". But are there any reasons to allow us to DROP such tables?
Itseems to me that the onlycasewhenwemay need itis the removal of orphan tables. Buttheautovacuumisresponsible for this andituses a differentfunctionality. I'm wondering if there areanyothercases. If not, can we just handle it for example in ExecDropStmt and produce an error like "cannot drop temporary tables of other sessions"?