Re: call the same pl/pgsql procedure twice in the same connection - Mailing list pgsql-sql

From Richard Huxton
Subject Re: call the same pl/pgsql procedure twice in the same connection
Date
Msg-id 200204181822.39563.richardh@archonet.com
Whole thread Raw
In response to Re: call the same pl/pgsql procedure twice in the same connection  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-sql
On Thursday 18 April 2002 17:43, Jan Wieck wrote:
> Bruce Momjian wrote:
> > Jan, instead of doing cache invalidation to fix temporary tables, can we
> > disable cached plans for functions that use temporary tables?
>
>     I  was  thinking  of  a different approach. Enhancing the SPI
>     manager to detect if a plan uses  temporary  objects
...

Was there not some talk of tracking dependencies between all objects (to avoid 
the problems with dropping referenced tables/functions). If so, it sounds 
like this is part of that future things job.

- Richard Huxton


pgsql-sql by date:

Previous
From: Thomas Swan
Date:
Subject: Re: how to get index scan at work?
Next
From: Richard Huxton
Date:
Subject: Re: SQL Query Optimization