Mark Volpe <volpe(dot)mark(at)epamail(dot)epa(dot)gov> writes:
> BEGIN;
> SELECT * INTO TEMP numbers2 FROM numbers;
> SELECT * FROM numbers2;
> -- Bang!!! --
> Can anybody reproduce this?
Yah :-(. There are several nasty bugs in 6.5.*'s support for TEMP
tables. We believe they are all fixed for 7.0, but the changes are
intertwined with a lot of other stuff, and so back-patching the fixes
didn't look very practical.
The only good news is that 7.0 goes beta next week...
regards, tom lane