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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
