Timestamp from an OID?
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
is a serial integer for the primary key on the table.
The server version 8.1.4
Thanks
Dennis
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.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
On Sep 12, 2007, at 8:32 , Dennis Muhlestein wrote:
Is there a way to find out when the previous rows were inserted?
There is a serial integer for the primary key on the table.
Nope.
Michael Glaesemann
grzm seespotcode net
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.
Thank to depesz on IRC for the proposal.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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