Re: BUG #6205: ERROR: temporary tables cannot specify a schema name

On Wed, Sep 14, 2011 at 4:49 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
>
> Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33 -0300 2011:
>
>> Cannot create temporary tables without using CREATE TEMP,
>> if I hardcode 'pg_temp' as a schema _and_ the table uses
>> a unique constraint on a column, this does work if the table
>> doesn't use a unique constraint:
>>
>> To reproduce:
>>
>> $ psql -U postgres _n_srv
>> psql (9.1.0)
>> Type "help" for help.
>>
>> _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.
>
> --
> Álvaro Herrera <alvherre(at)commandprompt(dot)com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

Yes, this was working in 9.0.4.