Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Why don't we create temp tables in a separate directory, anyway? That
> would make it trivially easy to get rid of them during recovery: just
> zap all the files in there.
Hmm ... doesn't do anything to fix the problem of file leakage for
crashes when making/deleting non-temp tables, but at least we could be
reasonably confident we weren't throwing away any data someone had a
long-term interest in.
regards, tom lane