[GENERAL] More details on Database corruption

Hi,

I managed to recreate a simple example that's crashing postgres.  I am
running on a DEC Alpha with Digital Unix Version 4.0d and Postgres
3.2.   I tried this example several times, on several databases and it
crashes every time.  We also re-built Postgres and still did not work.
Here's the example. Can anybody please help?

Thank you...
George K.
/***** INPUT FILE: hist.sql *******/

drop table tasks;
CREATE TABLE tasks (
task  INT4 NOT NULL,
job  INT4 NOT NULL,
Version1 CHAR(6) DEFAULT '',
Version2 CHAR(6) DEFAULT '',
Version3 CHAR(6) DEFAULT '',
Version4 CHAR(6) DEFAULT '',
Version5 CHAR(6) DEFAULT ''
);

INSERT INTO tasks (task, job) VALUES (1, 1);
select * from tasks;
update tasks set version1='1',version2='2', version3='3', version4='4',
version5='5' where task=1;
select * from tasks;


/****** OUTPUT FROM pgsql **********/
test=> \i hist.sql
drop table tasks;
DROP
CREATE TABLE tasks (
task            INT4 NOT NULL,
job             INT4 NOT NULL,
Version1        CHAR(6) DEFAULT '',
Version2        CHAR(6) DEFAULT '',
Version3        CHAR(6) DEFAULT '',
Version4        CHAR(6) DEFAULT '',
Version5        CHAR(6) DEFAULT ''
);
CREATE

INSERT INTO tasks (task, job) VALUES (1, 1);
INSERT 4410388 1
select * from tasks;
task|job|version1|version2|version3|version4|version5
----+---+--------+--------+--------+--------+--------
   1|  1|        |        |        |        |
(1 row)

update tasks set version1='1',version2='2', version3='3', version4='4',
version5='5' where task=1;
UPDATE 1
select * from tasks;
FATAL:  unrecognized data from the backend.  It probably dumped core.
FATAL:  unrecognized data from the backend.  It probably dumped core.

EOF
test=>







--ELM904013936-3186-0_

--ELM904013936-3186-0_--