Re: [BUGS] Temp table woes

2007-06-22 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> 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

[BUGS] Temp table woes

2007-06-22 Thread Heikki Linnakangas
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=# SELECT * FROM pg_temp_1.foo; x --- (0 rows) postgres=# INSERT INTO pg_temp_1.foo values (1); INSERT 0 1 The insert in session 2 goes to a buffe