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
\gor 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