Re: Removal of temp tables

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> If you don't like pg_temp here, maybe post_temp? pgsql_temp?

> What if I call the directory tmp or pgsql_tmp and the files
> pgsql_pid_#.#?

Why are you so eager not to call temp files "temp"? If you want to
spell it "pgsql_tmp" or "pg_temporary" or something different from
"pg_temp", that's fine, but I really think the files ought to clearly
label themselves as temporary. "pid" is not a clear label. With a
name like that, people might even think they are lock files.

regards, tom lane