Postgres Pro
Downloads
Home   >   mailing lists

Re: How Does TEMP Table Work In Plpgsql? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: How Does TEMP Table Work In Plpgsql?
Date
Msg-id Pine.BSF.4.21.0109032112030.79177-100000@megazone23.bigpanda.com
Whole thread Raw
In response to How Does TEMP Table Work In Plpgsql?  (<cnliou@eurosport.com>)
List pgsql-general
Tree view 
> Weid is that test2 and test work only once per psql
> connection (i.e. "session", am I correct?).
> Can anyone help?

The reason is that the query plans are getting cached.
AFAIK, if you want to work with temp tables in plpgsql,
you're going to need to use EXECUTE to generate all the
queries that relate to the temp table.

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Crash in vacuum analyze
Next
From: "James F. Hranicky"
Date:
Subject: Unexpected Behavior Using a Rule With Multiple Actions (Long)