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