Re: timestamp bug 7.4beta3 - Mailing list pgsql-bugs

From Neil Conway
Subject Re: timestamp bug 7.4beta3
Date
Msg-id 1066229423.28994.738.camel@tokyo
Whole thread Raw
In response to timestamp bug 7.4beta3  ("Nayib Kiuhan" <nayib@onlinetec.net>)
List 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

pgsql-bugs by date:

Previous
From: Tomas Szepe
Date:
Subject: Re: timestamp bug 7.4beta3
Next
From: Neil Conway
Date:
Subject: Re: timestamp bug 7.4beta3