Re: [HACKERS] defalut value

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