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

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