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

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 (view raw or flat)
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

pgsql-bugs by date

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

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