Re: timestamp goober - Mailing list pgsql-general

From Manuel Sugawara
Subject Re: timestamp goober
Date
Msg-id m3lmrh2kht.fsf@dep1.fciencias.unam.mx
Whole thread Raw
In response to timestamp goober  (Culley Harrelson <culleyharrelson@yahoo.com>)
List pgsql-general
Culley Harrelson <culleyharrelson@yahoo.com> writes:

> columns with default timestamp('now') see to be
> defaulting to the time I started posgresql!

try using: default 'now' instead of: default timestamp('now') in your
table definitions. The latter is evaluated by postgres just once, when
the table is installed, instead of each time a tuple is inserted.

HTH,
Manuel.

pgsql-general by date:

Previous
From: Brice Ruth
Date:
Subject: Re: [SQL] Query never returns ...
Next
From: Emmanuel Pierre
Date:
Subject: serious performance problem