'Default' troubles again. This time with time :)))

From: Leon <leon(at)udmnet(dot)ru>
To: bughunters <pgsql-bugs(at)postgresql(dot)org>
Subject: 'Default' troubles again. This time with time :)))
Date: 1999-07-18 09:52:58
Message-ID: 3791A3FA.34D647B3@udmnet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 1999-07-18 14:27:31 Re: [BUGS] 'Default' troubles again. This time with time :)))
Previous Message Leon 1999-07-18 09:47:45 Re: [BUGS] Frontend coredumps on NOTICE