On Wed, Sep 14, 2011 at 4:49 PM, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > > 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 >
Yes, this was working in 9.0.4. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
