[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Temporary Table Problem
From:       Stephan Szabo <sszabo () megazone23 ! bigpanda ! com>
Date:       2001-09-29 6:06:38
[Download RAW message or body]


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.




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[prev in list] [next in list] [prev in thread] [next in thread]