The following bug has been logged online: Bug reference: 6205 Logged by: Abel Abraham Camarillo Ojeda Email address: acam...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
