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

On Wed, Sep 14, 2011 at 4:49 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
>
> Excerpts from Abel Abraham Camarillo Ojeda's message of mi=C3=A9 sep 14 1=
8: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=3D# create table pg_temp.c (x int);
>> CREATE TABLE
>> _n_srv=3D# drop table pg_temp.c;
>> DROP TABLE
>> _n_srv=3D# create table pg_temp.c (x int unique);
>> ERROR: =C2=A0temporary tables cannot specify a schema name
>
> FWIW this does work in 9.0.
>
> --
> =C3=81lvaro Herrera <alvherre@commandprompt.com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

Yes, this was working in 9.0.4.