Skip site navigation (1) Skip section navigation (2)

Re: temporary table / recursion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Wimmer" <seppwimmer(at)hotmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: temporary table / recursion
Date: 2007-02-11 17:41:16
Message-ID: 1940.1171215676@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
"Robert Wimmer" <seppwimmer(at)hotmail(dot)com> writes:
> i cannot drop a temporary table that was created in a plpgsql function.

It was created with "on commit drop".  Are you sure it still exists?

The problem looks to me like the well-known issue that plpgsql caches
plans, and so you can't have it refer to different temp tables on
successive executions (in the same session) unless you use EXECUTE.

			regards, tom lane

In response to

pgsql-interfaces by date

Next:From: Robert WimmerDate: 2007-02-11 20:57:35
Subject: Re: temporary table / recursion
Previous:From: imadDate: 2007-02-11 17:27:31
Subject: Re: temporary table / recursion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group