dropping a table, leaving actual file in base/db/...

we have a process which uses a transaction to a bunch of:

begin work;
select * into tmptable from main table;
commit work;
drop table tmptable;


sometimes (always?) tmptable gets dropped from the database, but for
some reason the file /usr/pgsql/data/base/dbname/tmptable does not get
deleted.

this means that the next select into tmptable and/or create table tmptable
fails because it can't create the table.

anyone know what's up, or a work around?

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]