Re: timestamp goober

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "Culley Harrelson" <culleyharrelson(at)yahoo(dot)com>
Cc: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: timestamp goober
Date: 2001-02-08 16:31:10
Message-ID: 002a01c091ec$8bffcb40$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

I noticed that timestamps (in my case CURRENT_TIMESTAMP) are taken from the
beginning of a transaction. You didn't mention how you were accessing the
database, but if you were updating everything inside the same transaction,
everything would be timestamped with the time that transaction began.

Greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ned Lilly 2001-02-08 16:34:15 Re: [GENERAL] Re: full text searching
Previous Message Adam Lang 2001-02-08 16:26:58 Fw: [PHP] Fooling the query optimizer