Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sun, 11 Feb 2007 12:41:16 -0500
"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
- References:
- temporary table / recursion
- From: Robert Wimmer
- temporary table / recursion
- Prev by Date: Re: temporary table / recursion
- Next by Date: Re: temporary table / recursion
- Previous by thread: Re: temporary table / recursion
- Next by thread: Re: temporary table / recursion
- Indexes: