Re: temporary tables, plpgsql and yes i bet this has been asked before

Murray Prior Hobbs <murray@efone.com> writes:
> in a plpgsql function
>     create temporary table X
>     ....
>     drop table X

You need to use EXECUTE for all accesses to the temp table, in order
to defeat plpgsql's attempts to cache plans for those queries.
        regards, tom lane