IIRC, any things where you're doing creates/drops
in plpgsql pretty much mean you have to generate
the statements as strings and use EXECUTE which
will prevent the plans from being cached.
On Fri, 28 Sep 2001, Dinesh Parikh wrote:
> Dear all, I have a strange problem.Document says that one can create a
> temporary table in a session. I had created a temporary table in
> languge plpgsql.(Actually in a procedure). After completing my task I
> droped a table within a seesion(In same Function). Now problem arises.
> When I again calles that stored procedure (Function) then it says
> relation does not exist . What may be the cause of that problem. It is
> urgent. I need ed thi function as internal function so it called again
> and again.