Re: [GENERAL] How to tame a gigantic (100+ lines) query in a web app?

[Sim Zacks]

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