SEO

#1 (**permalink**) 04-10-2008, 08:40 AM

> Given the error message, this seems to be the whole plpgsql caches
> query plans but we don't invalidate those plans when there are schema
> changes. In all currently released versions you pretty much need to
> use EXECUTE on any queries where the table may go away, for example,
> any use of temp tables.

FWIW, this is documented behaviour (section 35.1 of the manual).

-roy

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2 (**permalink**) 04-10-2008, 08:40 AM

>>>>> "Roy" == Roy Badami <roy@gnomon.org.uk> writes:

Roy> FWIW, this is documented behaviour (section 35.1 of the
Roy> manual).

That's 35.1 in the 8.0 doc, BTW. It's 37.1 in the 7.4 doc.

Roy> -roy

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: BUG #1546: Temp table isn't deleted at the end of a