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 LAA45303 for ; Wed, 16 Feb 2000 11:36:02 -0500 (EST) (envelope-from volpe.mark@epamail.epa.gov) Received: from epamail.epa.gov (IDENT:mvs@wolfpack.rtpnc.epa.gov [134.67.139.59]) by nts1.rtp.epa.gov (8.9.3/8.9.3) with ESMTP id LAA01856 for ; Wed, 16 Feb 2000 11:39:00 -0500 (EST) Sender: mvs@nts1.rtp.epa.gov Message-ID: <38AAD1E2.BBFDFD37@epamail.epa.gov> Date: Wed, 16 Feb 2000 11:35:46 -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: Postgres backend crash on alpha Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The following sequence causes the backend to crash: CREATE TABLE test1 (a text); CREATE TABLE test2 (b text); CREATE RULE test_insert AS ON INSERT TO test1 DO INSTEAD INSERT INTO test2 VALUES (NEW.a); INSERT INTO test1 VALUES ('crash'); For some reason this only occurs on the alpha platform (tried on alpha and linux). If I try this using ints it works fine, though. And the use of "NEW" seems to be what's screwing it up. Is there a fix for this? It is crashing in the _copyConst function on this line: length = VARSIZE(from->constvalue) Thanks, Mark