Received: from finch-post-12.mail.demon.net (finch-post-12.mail.demon.net [194.217.242.41]) by postgresql.org (Postfix) with ESMTP id C6AFA475452 for ; Thu, 18 Apr 2002 13:23:10 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by finch-post-12.mail.demon.net with esmtp (Exim 3.35 #1) id 16yFcc-000JqK-0C; Thu, 18 Apr 2002 17:23:02 +0000 Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 6325113B9E; Thu, 18 Apr 2002 18:22:39 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Jan Wieck Subject: Re: call the same pl/pgsql procedure twice in the same connection Date: Thu, 18 Apr 2002 18:22:39 +0100 X-Mailer: KMail [version 1.4] Cc: pgsql-sql@postgresql.org References: <200204181643.g3IGhUw14564@saturn.janwieck.net> In-Reply-To: <200204181643.g3IGhUw14564@saturn.janwieck.net> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200204181822.39563.richardh@archonet.com> X-Archive-Number: 200204/245 X-Sequence-Number: 7509 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