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

From Robert Haas
Subject Re: BUG #6205: ERROR: temporary tables cannot specify a schema name
Date
Msg-id CA+TgmoZW9UqqpVEnSbXG5QfeO6vUtaRG9TDA6jMQ1rRY4wAgxA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6205: ERROR: temporary tables cannot specify a schema name  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #6205: ERROR: temporary tables cannot specify a schema name
List pgsql-bugs
On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> Excerpts from Abel Abraham Camarillo Ojeda's message of mi=E9 sep 14 18:=
33:33 -0300 2011:
>>> _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: =A0temporary 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.

Yeah, looks like it.  Will investigate.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #6208: crash when c: occupied by removable drive
Next
From: "Ramanujam"
Date:
Subject: BUG #6213: COPY does not work as expected in a plpgsql function