Skip site navigation (1) Skip section navigation (2)

Re: Temp table woes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Temp table woes
Date: 2007-06-22 15:12:08
Message-ID: 22537.1182525128@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Heikki Linnakangas <heikki(at)enterprisedb(dot)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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-06-22 15:26:26
Subject: Re: Error message that is a bit misleading / weird result from <xid> || null
Previous:From: Zdenek KotalaDate: 2007-06-22 13:30:44
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group