This is now fixed in 6.5.
> Is this a known problem?
>
> CREATE TABLE test (
> plt int2 PRIMARY KEY,
> state CHAR(5) NOT NULL DEFAULT 'new',
> used boolean NOT NULL DEFAULT 'f',
> id int4
> );
>
> INSERT INTO test (plt, id) VALUES (1, 1);
> INSERT INTO test (plt, id) VALUES (2, 2);
> INSERT INTO test (plt, id) VALUES (3, 3);
>
> SELECT * FROM test;
>
> plt|state|used|id
> ---+-----+----+--
> 1|new |f | 1
> 2|new |f | 2
> 3|new |f | 3
> (3 rows)
>
> UPDATE test SET state = 'diff' WHERE plt = 1;
> SELECT * FROM test;
>
> plt|state|used| id
> ---+-----+----+-----
> 2|new |f | 2
> 3|new |f | 3
> 1|diff |t |26144
> (3 rows)
>
> ???
> --
> Tatsuo Ishii
>
>
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026