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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]