Thread: Backend crash

Backend crash

From
Mark Volpe
Date:
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