Re: temp table problem - Mailing list pgsql-hackers

From Tom Lane
Subject Re: temp table problem
Date
Msg-id 29446.1216569877@sss.pgh.pa.us
Whole thread Raw
In response to Re: temp table problem  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-hackers
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> The underlying problem is that when we do GetOverrideSearchPath() in 
> CreateCachedPlan, the memorized search path doesn't include pg_temp, if 
> the temp namespace wasn't initialized for the backend yet. When we later 
> need to revalidate the plan, pg_temp still isn't searched, even if it 
> now exists.

So what's the problem?  The cached plan couldn't have referred to a temp
table.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [PATCHES] WITH RECUSIVE patches 0717
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] WITH RECUSIVE patches 0717