Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 190DA476620; Wed, 3 Jul 2002 19:09:51 -0400 (EDT) Mailbox-Line: From mark@somanetworks.com Wed Jul 3 19:09:51 2002 Received: from frogger.yyz.somanetworks.com (gw-yyz.somanetworks.com [216.126.67.39]) by postgresql.org (Postfix) with ESMTP id 91A8B4764A4; Wed, 3 Jul 2002 17:12:36 -0400 (EDT) Received: by frogger.yyz.somanetworks.com (Postfix, from userid 506) id 696B323B43; Wed, 3 Jul 2002 17:12:32 -0400 (EDT) Date: Wed, 3 Jul 2002 17:12:32 -0400 From: Mark Frazer To: pgsql-sql@postgresql.org, pgsql-interfaces@postgresql.org Subject: Re: Possible Bug regarding temp tables (sql or psql?) Message-ID: <20020703171232.Z1375@somanetworks.com> References: <20020703165903.A17844@somanetworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20020703165903.A17844@somanetworks.com>; from mark@somanetworks.com on Wed, Jul 03, 2002 at 04:59:03PM -0400 X-Message-Flag: Outlook not so good. Organization: Detectable, well, not really X-Bender: Well I don't have anything else planned for today, let's get drunk! X-Spam-Status: No, hits=-3.4 required=5.0 tests=IN_REP_TO version=2.30 X-Spam-Level: X-Archive-Number: 200207/6 X-Sequence-Number: 2815 Forgot to mention that adding DROP TABLE v_idx ; before the END WORK will fix things. However, I was under the impression that temporary tables would go away after a transaction in which they were created was committed.