Re: timestamp goober

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Culley Harrelson <culleyharrelson(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp goober
Date: 2001-02-08 16:43:42
Message-ID: m3lmrh2kht.fsf@dep1.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Culley Harrelson <culleyharrelson(at)yahoo(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-02-08 16:47:38 Re: [SQL] Query never returns ...
Previous Message David Wheeler 2001-02-08 16:37:35 TOAST