'Default' troubles again. This time with time :))) - Mailing list 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.