The following bug has been logged online:
Bug reference: 6205
Logged by: Abel Abraham Camarillo Ojeda
Email address: acamari@verlet.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
