From: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <abbas(dot)butt(at)enterprisedb(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: temp table problem |
Date: | 2008-07-20 15:27:06 |
Message-ID: | 4883594A.9020808@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> What PG version are you testing? Maybe you need to show a complete
> test case, instead of leaving us to guess at details?
I think that example is bogus. Let's forget that one, and look at the
attached script.
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.
(On 8.3 and CVS HEAD)
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
temp-table-invisible.sql | text/plain | 596 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2008-07-20 15:42:16 | Re: [PATCHES] WITH RECUSIVE patches 0717 |
Previous Message | Tom Lane | 2008-07-20 13:48:15 | Re: Getting to universal binaries for Darwin |