Re: How Does TEMP Table Work In Plpgsql?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: cnliou(at)eurosport(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How Does TEMP Table Work In Plpgsql?
Date: 2001-09-04 04:14:06
Message-ID: Pine.BSF.4.21.0109032112030.79177-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James F. Hranicky 2001-09-04 04:21:40 Unexpected Behavior Using a Rule With Multiple Actions (Long)
Previous Message Sean Chittenden 2001-09-04 03:24:11 Re: Crash in vacuum analyze