4/24/03 12:22:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net> writes:
>> With my "kill [procnum]" I don't seem to have any negative side
>> effects, except apparently for the temp tables (I _think_). Does that
>> seem reasonable?
>
>No, a normal kill (SIGTERM) should run proc_exit callbacks, including
>temp-table cleanup. There must be something else going on.
>
> regards, tom lane
OK, Option 2: I use an SSH connection to tunnel port 5432 from my Windows
machine to the DB machine (Red Hat 7.3); occasionally the SSH connection
drops, and so does the tunnel. Could that explain the temp tables?
Thanks,
Andrew Biagioni