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 NAA98616 for ; Wed, 16 Feb 2000 13:18:26 -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 NAA13763; Wed, 16 Feb 2000 13:20:04 -0500 (EST) Sender: mvs@nts1.rtp.epa.gov Message-ID: <38AAE991.791D8E2@epamail.epa.gov> Date: Wed, 16 Feb 2000 13:16:49 -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: Bruce Momjian CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Postgres backend crash on alpha References: <200002161658.LAA03180@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Yup, it's fixed. Bruce Momjian wrote: > > I would like you to try this on the current snapshot on our ftp server. > I suspect it has been fixed, but if not, we would like to get it fixed > because we are starting beta in a few days. > > > 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 > > > > ************ > > > > > > -- > Bruce Momjian | http://www.op.net/~candle > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ************