Is there anything dangerous about making temporary tables in this way? Matt
The only dangerous thing I have encountered with temp tables is that the planner compiles the table oid into the plan and if you run a function after the table has been dropped and recreated it will tell you that the table doesn't exist. This is from 8.2 and lower, I haven't checked if this is still a problem in more recent versions.
Sim