temp tables broken in CVS HEAD?
От | Oliver Jowett |
---|---|
Тема | temp tables broken in CVS HEAD? |
Дата | |
Msg-id | 40B747FD.1090407@opencloud.com обсуждение исходный текст |
Ответы |
Re: temp tables broken in CVS HEAD?
|
Список | 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 \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
В списке pgsql-hackers по дате отправления: