>>>>> "Rick" == Rick Otten <rotten@windfish.net> writes:
Rick> Is t1 also the tablespace for your materialized view? (It isn't
Rick> clear from what you've posted below.)
No. The matview was created in pg_default.
Rick> In my environment my default tablespace for the database is
Rick> different than the temp_tablespace.
Possibly relevant here is that to put a tablespace into
temp_tablespaces, you must have CREATE permission on it. If you set the
value in postgresql.conf rather than with SET, you may not see errors
from lack of permission, instead tablespaces without permission will be
silently omitted.
--
Andrew (irc:RhodiumToad)