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?