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
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 |