Re: BUG #6205: ERROR: temporary tables cannot specify a schema name - Mailing list pgsql-bugs

Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33 -0300 2011:

> 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

FWIW this does work in 9.0.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support