On 08/14/2011 05:39 PM, W. Matthew Wilson wrote:
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