| From: | Dennis Muhlestein <djmuhlestein(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Timestamp from an OID? |
| Date: | 2007-09-12 14:51:19 |
| Message-ID: | fc8ubk$moh$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Harrison | 2007-09-12 15:35:10 | update problem in partitioned tables |
| Previous Message | Alban Hertroys | 2007-09-12 14:16:31 | Re: avg() of array values |