| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Abel Abraham Camarillo Ojeda <acamari(at)verlet(dot)org>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #6205: ERROR: temporary tables cannot specify a schema name |
| Date: | 2011-09-18 21:10:05 |
| Message-ID: | CA+TgmoZW9UqqpVEnSbXG5QfeO6vUtaRG9TDA6jMQ1rRY4wAgxA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)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.
Yeah, looks like it. Will investigate.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramanujam | 2011-09-19 02:55:10 | BUG #6213: COPY does not work as expected in a plpgsql function |
| Previous Message | Craig Ringer | 2011-09-18 10:40:08 | Re: BUG #6208: crash when c: occupied by removable drive |