[HACKERS] temp tables broken in CVS HEAD?

[Oliver Jowett]

Against current CVS HEAD:
$ ./createuser test
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
$ ./createdb -O test test
CREATE DATABASE
$ ./psql -U test test
Welcome to psql 7.5devel, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit
test=> \l
       List of databases
   Name    | Owner  | Encoding
-----------+--------+-----------
 template0 | oliver | SQL_ASCII
 template1 | oliver | SQL_ASCII
 test      | test   | SQL_ASCII
(3 rows)
test=> create table t1 (i int);
CREATE TABLE
test=> create temp table t2 (i integer);
ERROR:  permission denied for schema pg_temp_1
test=> select * from pg_namespace;
      nspname       | nspowner |             nspacl
--------------------+----------+---------------------------------
 pg_toast           |        1 |
 pg_temp_1          |        1 |
 pg_catalog         |        1 | {oliver=U*C*/oliver,=U/oliver}
 public             |        1 | {oliver=U*C*/oliver,=UC/oliver}
 information_schema |        1 | {oliver=U*C*/oliver,=U/oliver}
(5 rows)
The same thing under 7.4.2 successfully creates the temp table. I think 
this is something recent as it's triggered by the JDBC driver's 
regression tests, which ran (under the same conditions IIRC) without 
problems against CVS HEAD as of about a week ago.

-O
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings