Igor <dbmanager(at)osb368(dot)nnov(dot)ru> writes:
> Sorry, I clean forgot to tell ....
> I'm running PG v7.02.
Ah. Update to 7.0.3 (or even better 7.1, but 7.0.3 is a drop-in
replacement with no need for dump/reload). I think you are getting
bit by a known bug in 7.0.2: if the client disconnects partway through
a transaction, the backend forgets to clean up before it exits. That's
probably why you have these partially-removed temp tables laying about.
regards, tom lane