Skip site navigation (1) Skip section navigation (2)

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

From: Abel Abraham Camarillo Ojeda <acamari(at)verlet(dot)org>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6205: ERROR: temporary tables cannot specify a schema name
Date: 2011-09-14 22:45:01
Message-ID: CAPD=2NgKN9RZX_JhJafLaLB4CD07UFEPaBqRr0hEt_c=de31zA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2011-09-15 03:45:52
Subject: Re: Dropped index on table preventing rule creation
Previous:From: Alex HunsakerDate: 2011-09-14 22:17:53
Subject: Re: BUG #6204: Using plperl functions generate crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group