X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9319DD1B4EE for ; Thu, 18 Sep 2003 12:37:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 48539-05 for ; Thu, 18 Sep 2003 09:37:06 -0300 (ADT) Received: from pns.mm.eutelsat.org (pns.mm.eutelsat.org [194.214.173.227]) by svr1.postgresql.org (Postfix) with ESMTP id B1015D1B4E5 for ; Thu, 18 Sep 2003 09:37:01 -0300 (ADT) Received: from nts-03.mm.eutelsat.org (localhost [127.0.0.1]) by pns.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id h8IBcPS16782; Thu, 18 Sep 2003 13:38:28 +0200 Received: from bigfoot.com (gmendola2.mm.eutelsat.org [194.214.173.26]) by nts-03.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id h8ICUMR11739; Thu, 18 Sep 2003 14:30:23 +0200 Message-ID: <3F69A6DE.1050002@bigfoot.com> Date: Thu, 18 Sep 2003 14:36:46 +0200 From: Gaetano Mendola User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030901 Thunderbird/0.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-hackers@postgresql.org" Cc: Tom Lane Subject: Re: observations about temporary tables and schemas References: <2054.1063808792@sss.pgh.pa.us> In-Reply-To: <2054.1063808792@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/1014 X-Sequence-Number: 44026 Tom Lane wrote: > I think we have two choices: disallow foreign-key references from temp > tables to permanent tables, or take out the optimization of storing > temp table pages in private memory. (That would leave the whole "local > buffer manager" module as dead code, I think.) I'm kinda leaning > towards the first; does anyone feel that it's a valuable feature to keep? My vote is for remove this feature. Regards Gaetano Mendola