Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA66956 for ; Mon, 24 Jan 2000 12:16:58 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id MAA25646; Mon, 24 Jan 2000 12:16:56 -0500 (EST) To: Mark Volpe cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Backend crash In-reply-to: <388C7CF1.602FE3CD@epamail.epa.gov> References: <388C7CF1.602FE3CD@epamail.epa.gov> Comments: In-reply-to Mark Volpe message dated "Mon, 24 Jan 2000 11:25:21 -0500" Date: Mon, 24 Jan 2000 12:16:56 -0500 Message-ID: <25643.948734216@sss.pgh.pa.us> From: Tom Lane Mark Volpe writes: > BEGIN; > SELECT * INTO TEMP numbers2 FROM numbers; > SELECT * FROM numbers2; > -- Bang!!! -- > Can anybody reproduce this? Yah :-(. There are several nasty bugs in 6.5.*'s support for TEMP tables. We believe they are all fixed for 7.0, but the changes are intertwined with a lot of other stuff, and so back-patching the fixes didn't look very practical. The only good news is that 7.0 goes beta next week... regards, tom lane