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