RE: timestamp variable type losing data

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?