Postgres backend crash on alpha - Mailing list pgsql-sql

From Mark Volpe
Subject Postgres backend crash on alpha
Date
Msg-id 38AAD1E2.BBFDFD37@epamail.epa.gov
Whole thread Raw
Responses Re: [SQL] Postgres backend crash on alpha  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] Re: BSC
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Postgres backend crash on alpha