Re: Temp table woes - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Temp table woes
Date
Msg-id 22537.1182525128@sss.pgh.pa.us
Whole thread Raw
In response to Temp table woes  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Next
From: Tom Lane
Date:
Subject: Re: Error message that is a bit misleading / weird result from || null