Re: BUG #6205: ERROR: temporary tables cannot specify a schema name - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6205: ERROR: temporary tables cannot specify a schema name
Date
Msg-id 17052.1316059526@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6205: ERROR: temporary tables cannot specify a schema name  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: BUG #6205: ERROR: temporary tables cannot specify a schema name  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33 -0300 2011:
>> _n_srv=# create table pg_temp.c (x int);
>> CREATE TABLE
>> _n_srv=# drop table pg_temp.c;
>> DROP TABLE
>> _n_srv=# create table pg_temp.c (x int unique);
>> ERROR:  temporary tables cannot specify a schema name

> FWIW this does work in 9.0.

In that case I'm betting Robert broke it somewhere in the unlogged-table
changes.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dropped index on table preventing rule creation
Next
From: Craig Ringer
Date:
Subject: Re: BUG #6206: The reset button is always blocked in case of error in the backup file.