Emmanuel Cecchet <manu(at)asterdata(dot)com> writes:
> Following the issue with temp tables and 2PC, we thought that each
> session in Postgres was supposed to generate a unique namespace for its
> temporary tables.
You made that up out of sheer wishful thinking. There is one pg_temp
schema per backendid slot.
regards, tom lane