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 |
- [GENERAL] How to tame a gigantic (100+ lines) query in a... W. Matthew Wilson
- Re: [GENERAL] How to tame a gigantic (100+ lines) q... Peter Bex
- Re: [GENERAL] How to tame a gigantic (100+ lines) q... Rob Sargent
- Re: [GENERAL] How to tame a gigantic (100+ lines) q... Sim Zacks
- Re: [GENERAL] How to tame a gigantic (100+ lines) q... Thomas Markus