On Thu, 13 Aug 1998, George Kousi wrote:
> 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 ''
> );
A zero-length string ('') is not a valid default value for a CHAR(6).
I replaced it with ' ' (six blanks) and all runs fine.
I run 6.3.1 on Linux 2.0.27 and your script fails on the first insert
without corruption problems. I don't know why it only fails on update on
your system.
Regards - guido
------------------------------------------------------------------------
// Guido Carlo Piazzi Accompagnatore naturalistico
// gpiazzi@nemo.it Visitate il sito WWW.ParcoDelTicino.Pmn.It
------------------------------------------------------------------------