Re: timestamp bug 7.4beta3

From: Neil Conway <neilc(at)samurai(dot)com>
To: Nayib Kiuhan <nayib(at)onlinetec(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: timestamp bug 7.4beta3
Date: 2003-10-15 14:50:24
Message-ID: 1066229423.28994.738.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 2003-10-15 at 02:08, Nayib Kiuhan wrote:
> In versions before 7.4beta3 I use to have tables with
> "date" timestamp DEFAULT 'now'
> 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.

>From the 7.4 HISTORY file:

'now' will no longer work as a column default, use now() (change
required for prepared statements) (Tom)

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.

-Neil

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nayib Kiuhan 2003-10-15 17:29:57 Re: timestamp bug 7.4beta3
Previous Message Tomas Szepe 2003-10-15 14:33:40 Re: timestamp bug 7.4beta3