Re: [BUGS] BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect

2005-03-20 Thread Oliver Siegmar
On Friday 18 March 2005 14:29, Stephan Szabo wrote: > 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. I already tried to execute the 'CREATE TEMP TABLE' statement using EXECUTE to avoid cache probl

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

2005-03-19 Thread Roy Badami
> "Roy" == Roy Badami <[EMAIL PROTECTED]> 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

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

2005-03-19 Thread Roy Badami
> 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 te

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

2005-03-18 Thread Stephan Szabo
On Fri, 18 Mar 2005, Oliver Siegmar wrote: > On Friday 18 March 2005 14:29, Stephan Szabo wrote: > > 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. > > I already tried to execute the 'CREATE TEM

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

2005-03-18 Thread Stephan Szabo
On Tue, 15 Mar 2005, Oliver Siegmar wrote: > Here's a demonstration of the bug: > > CREATE FUNCTION testfunction() > RETURNS void > AS ' > BEGIN > CREATE TEMP TABLE testtable (field int4) ON COMMIT DROP; > > INSERT INTO testtable (field) VALUES (1); > > -- DROP TABLE te

[BUGS] BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect

2005-03-17 Thread Oliver Siegmar
The following bug has been logged online: Bug reference: 1546 Logged by: Oliver Siegmar Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 / 8.0.1 Operating system: Linux x86 Description:Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has