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 LAA47210 for ; Mon, 24 Jan 2000 11:24:32 -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 LAA02383 for ; Mon, 24 Jan 2000 11:27:27 -0500 (EST) Sender: mvs@nts1.rtp.epa.gov Message-ID: <388C7CF1.602FE3CD@epamail.epa.gov> Date: Mon, 24 Jan 2000 11:25:21 -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 To: pgsql-sql@postgresql.org Subject: Backend crash Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The following sequence causes PostgreSQL to crash on my Linux box: -- Any example table here will do CREATE TABLE numbers ( value int ); INSERT INTO numbers VALUES(1); INSERT INTO numbers VALUES(2); INSERT INTO numbers VALUES(3); INSERT INTO numbers VALUES(4); -- Now the crash sequence BEGIN; SELECT * INTO TEMP numbers2 FROM numbers; SELECT * FROM numbers2; -- Bang!!! -- Can anybody reproduce this? Thanks, Mark