my_temptablespace2: Fix pg_dumpall for temp tablespaces

SET spcoptions on CREATE TABLESPACE instead of a separate call for ALTER
TABLESPACE.