Re: Temp table woes

Heikki Linnakangas <heikki@enterprisedb.com> writes:
> This only works as a superuser, but it's wrong nevertheless:

> Session 1:
> postgres=# CREATE temp table foo (x int);
> CREATE TABLE

> Session 2:
> postgres=# INSERT INTO pg_temp_1.foo values (1);
> INSERT 0 1

I can't get excited about preventing that --- it looks to me like a
superuser deliberately trying to break the system, and there are plenty
of other ways he can do that.

            regards, tom lane