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