Re: Removal of temp tables

Bruce Momjian <pgman@candle.pha.pa.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