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

From: "Abel Abraham Camarillo Ojeda" <acamari(at)verlet(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6205: ERROR: temporary tables cannot specify a schema name
Date: 2011-09-14 21:33:33
Message-ID: 201109142133.p8ELXXkh073452@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6205
Logged by: Abel Abraham Camarillo Ojeda
Email address: acamari(at)verlet(dot)org
PostgreSQL version: 9.1.0
Operating system: OpenBSD-current/amd64
Description: ERROR: temporary tables cannot specify a schema name
Details:

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2011-09-14 21:49:04 Re: BUG #6205: ERROR: temporary tables cannot specify a schema name
Previous Message Brar Piening 2011-09-14 19:49:54 Re: Problem with the 9.1 one-click installer Windows7 64bit