Thread: 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