Received: from nts1.rtp.epa.gov (nts1.rtp.epa.gov [134.67.208.208]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA98661 for ; Mon, 24 Jan 2000 13:57:42 -0500 (EST) (envelope-from volpe.mark@epamail.epa.gov) Received: from epamail.epa.gov (IDENT:mvs@wolfpack.rtpnc.epa.gov [134.67.136.18]) by nts1.rtp.epa.gov (8.9.3/8.9.3) with ESMTP id OAA09628 for ; Mon, 24 Jan 2000 14:00:36 -0500 (EST) Sender: mvs@nts1.rtp.epa.gov Message-ID: <388CA0D4.F54D9D8F@epamail.epa.gov> Date: Mon, 24 Jan 2000 13:58:28 -0500 From: Mark Volpe X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.9-27mdk i586) X-Accept-Language: en MIME-Version: 1.0 CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Backend crash References: <388C7CF1.602FE3CD@epamail.epa.gov> <25643.948734216@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thanks, guys! SELECT * INTO ... works just fine for me :-) Tom Lane wrote: > > 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 > > ************