Temp table woes

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 buffer in the shared buffer cache,
which causes problems at the next checkpoint:

ERROR: could not open relation 1663/11502/24576: No such file or directory
CONTEXT: writing block 0 of relation 1663/11502/24576
WARNING: could not write block 0 of 1663/11502/24576
DETAIL: Multiple failures --- write error might be permanent.

Without superuser rights, you'll get a permission denied error trying to
access the table from another session.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com