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