Re: timestamp bug 7.4beta3
От | Nayib Kiuhan |
---|---|
Тема | Re: timestamp bug 7.4beta3 |
Дата | |
Msg-id | 000d01c39342$006c2d80$6e01030a@xxx обсуждение исходный текст |
Ответ на | timestamp bug 7.4beta3 ("Nayib Kiuhan" <nayib@onlinetec.net>) |
Список | pgsql-bugs |
Thank you for your answer. I tried before with 'now()' (inside the single a= spen) and didn't work . Now it is working very well without the aspens as y= ou already mentioned. It is a good idea to through out an error during the = table creation if the format is not as indicated (now()), because when I cr= eated my tables with the old format, it did not show any problem, I just fi= gure out that something was wrong with my tables once my java program start= to do weird things. Again, many thanks, Nayib ----- Original Message -----=20 From: "Neil Conway" <neilc@samurai.com> To: "Nayib Kiuhan" <nayib@onlinetec.net> Cc: <pgsql-bugs@postgresql.org> Sent: Wednesday, October 15, 2003 10:50 AM Subject: Re: [BUGS] timestamp bug 7.4beta3 > On Wed, 2003-10-15 at 02:08, Nayib Kiuhan wrote: > > In versions before 7.4beta3 I use to have tables with=20 > > "date" timestamp DEFAULT 'now'=20=20=20 > > It use to works properly, placing the actual date at the moment a new > > record was inserted. Now it always have the same date which correspond > > to the date at creating the table. >=20 > >From the 7.4 HISTORY file: >=20 > 'now' will no longer work as a column default, use now() (change > required for prepared statements) (Tom) >=20 > Admittedly, this change should also be noted in the 'migration to 7.4 > section' of the release notes -- I'll send a patch to this effect to > pgsql-patches. >=20 > -Neil >=20 >=20 >=20
В списке pgsql-bugs по дате отправления: