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=>
