Re: Timestamp from an OID? - Mailing list pgsql-general

From Dennis Muhlestein
Subject Re: Timestamp from an OID?
Date
Msg-id fc8ubk$moh$1@news.hub.org
Whole thread Raw
In response to Re: Timestamp from an OID?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
A. Kretschmer wrote:
> am  Wed, dem 12.09.2007, um 15:41:44 +0200 mailte A. Kretschmer folgendes:
>> am  Wed, dem 12.09.2007, um  7:32:45 -0600 mailte Dennis Muhlestein folgendes:
>>> I've been passively collecting data for a few months.  I realized, after
>>> a while, that I never added a timestamp column to the table the data is
>>> being stored in.  I've since added that.
>>>
>>> Is there a way to find out when the previous rows were inserted?  There
>> No.
>
> How many records per day? Maybe you can guess the approximate
> timestamps.
>

Thanks for the responses.  Actually, I can reconstruct the timestamps
from the access log on the web server that was recording the data.  I
was just curious if there was something hidden I didn't know about.

Thanks
Dennis

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: avg() of array values
Next
From: "Josh Harrison"
Date:
Subject: update problem in partitioned tables