Jerry Sievers <jerry@jerrysievers.com> writes:
> I'm running postgres 7.4.1 and notice an accumulation of temp schemas
> named pg_temp_1, pg_temp_2... etc.
That's intentional. Removing them just causes extra work to add them
again later (not to mention possibly crashing any backend that is
actively using one you remove).
regards, tom lane