Jim Jones <jim.jones@uni-muenster.de> writes:
> I also noticed that it is possible to LOCK a temp table from another
> session (as superuser).
Sure. Superusers bypass all SQL permissions checks.
> Doesn't it mean that one session can trivially DoS another session's
> private temp table?
Superusers can trivially DoS anybody anytime: lock their tables,
corrupt their data, whatever. That's a feature not a bug.
regards, tom lane