temp tables broken in CVS HEAD?

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: temp tables broken in CVS HEAD?
Date: 2004-05-28 14:09:01
Message-ID: 40B747FD.1090407@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jon Jensen 2004-05-28 14:15:38 Re: pg_dump --comment?
Previous Message Neil Conway 2004-05-28 13:54:48 contrib/ compile warnings