'Default' troubles again. This time with time :)))
Leon <leon@udmnet.ru>
From: Leon <leon@udmnet.ru>
To: bughunters <pgsql-bugs@postgresql.org>
Date: 1999-07-18T09:52:58Z
Lists: pgsql-bugs
Hello! Look at this: bdb=> create table dd (aa int4, gg timestamp default 'now'); CREATE bdb=> insert into dd (aa) values (5); INSERT 581771 1 bdb=> select * from dd; aa|gg --+---------------------- 5|1999-07-18 14:40:02+05 (1 row) So far so good. But some seconds later: bdb=> insert into dd (aa) values (6); INSERT 581772 1 bdb=> select * from dd; aa|gg --+---------------------- 5|1999-07-18 14:40:02+05 6|1999-07-18 14:40:02+05 (2 rows) See? Time haven't changed! And again: bdb=> insert into dd (aa) values (123); INSERT 581773 1 bdb=> select * from dd; aa|gg ---+---------------------- 5|1999-07-18 14:40:02+05 6|1999-07-18 14:40:02+05 123|1999-07-18 14:40:02+05 (3 rows) Seems there is lot'a trouble with default values :) -- Leon.