Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA49750 for ; Wed, 16 Feb 2000 11:59:16 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id LAA03180; Wed, 16 Feb 2000 11:58:07 -0500 (EST) From: Bruce Momjian Message-Id: <200002161658.LAA03180@candle.pha.pa.us> Subject: Re: [SQL] Postgres backend crash on alpha In-Reply-To: <38AAD1E2.BBFDFD37@epamail.epa.gov> from Mark Volpe at "Feb 16, 2000 11:35:46 am" To: Mark Volpe Date: Wed, 16 Feb 2000 11:58:07 -0500 (EST) CC: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL71 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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