Thread: timestamp variable type losing data
I hope I can explain this so it is understandable. I have an object within a table which has a variable type of 'timestamp'. This is the close_date for an in-house ticketing system. It has a relation to another table which has the listing of all of the administrators. The problem is that if one of the administrators leaves to go to another job and then we remove them, the timestamp value associated with all of the tickets that this admin has closed loses it's value. So, now we don't know when the tickets or tasks were completed from the past. I tried re-adding the admin but the timestamps do not return. I figure we probably lost the data, but I don't really want to lose it again. Has anyone come across this problem? Does anyone have any idea as to how to correct it? Thank you, David M. Fetter 503.450.6609 UNIX System Analyst Emery World Wide "It has become appallingly clear that our technology has surpassed our humanity." - Albert Einstein
Attachment
How are the two tables tied together (using foreign keys?) Without the schema, it's hard to know what might be going on. Stephan Szabo sszabo@bigpanda.com On Thu, 17 Aug 2000, Fetter, David M wrote: > I hope I can explain this so it is understandable. I have an object within > a table which has a variable type of 'timestamp'. This is the close_date > for an in-house ticketing system. It has a relation to another table which > has the listing of all of the administrators. The problem is that if one of > the administrators leaves to go to another job and then we remove them, the > timestamp value associated with all of the tickets that this admin has > closed loses it's value. So, now we don't know when the tickets or tasks > were completed from the past. I tried re-adding the admin but the > timestamps do not return. I figure we probably lost the data, but I don't > really want to lose it again. Has anyone come across this problem? Does > anyone have any idea as to how to correct it?
Actually, I already got it resolved, but thanks. -----Original Message----- From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com] Sent: Thursday, August 17, 2000 2:45 PM To: Fetter, David M Cc: PostgreSQL-General (E-mail) Subject: Re: [GENERAL] timestamp variable type losing data How are the two tables tied together (using foreign keys?) Without the schema, it's hard to know what might be going on. Stephan Szabo sszabo@bigpanda.com On Thu, 17 Aug 2000, Fetter, David M wrote: > I hope I can explain this so it is understandable. I have an object within > a table which has a variable type of 'timestamp'. This is the close_date > for an in-house ticketing system. It has a relation to another table which > has the listing of all of the administrators. The problem is that if one of > the administrators leaves to go to another job and then we remove them, the > timestamp value associated with all of the tickets that this admin has > closed loses it's value. So, now we don't know when the tickets or tasks > were completed from the past. I tried re-adding the admin but the > timestamps do not return. I figure we probably lost the data, but I don't > really want to lose it again. Has anyone come across this problem? Does > anyone have any idea as to how to correct it?