Re: BUG #3229: Incorrect temp table work

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: ALEXEY PARSHIN <alexeyp(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3229: Incorrect temp table work
Date: 2007-04-16 17:47:13
Message-ID: 4623B6A1.80909@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ALEXEY PARSHIN wrote:
> The following bug has been logged online:
>
> Bug reference: 3229
> Logged by: ALEXEY PARSHIN
> Email address: alexeyp(at)gmail(dot)com
> PostgreSQL version: 8.1.8
> Operating system: Gentoo Linux
> Description: Incorrect temp table work
> Details:
>
> If I call the following function two or more time, I get an error "relation
> with OID 318730 does not exist":

this is documented (and a workaround is mentioned as well) in the FAQ:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

and this will get improved (through plan invalidation) in the upcoming
8.3 release of postgresql too in a way that will not require the EXECUTE
workaround any more.

Stefan

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-04-16 18:06:51 Re: BUG #3231: Duplicate rows primary key bug
Previous Message Amorn Buchheit 2007-04-16 17:38:17 Submit bug report via bug web form - couldn't find the thread