[Info-ingres] Fw: tid and the date a row originally came into a table

[Allan Biggs]

----- Forwarded by Allan Biggs/GB/CONT/DPT on 28/05/2020 16:39 -----

From:   Allan Biggs/GB/CONT/DPT
To:     openroad-users at googlegroups.com, 
"info-ingres at lists.planetingres.org" <info-ingres at lists.planetingres.org>
Date:   28/05/2020 16:07
Subject:        Fw: tid and the date a row originally came into a table 




A colleague  has an issue with data being overwritten and some inserted by 
a feed from a plant system.

If we look at the table below rows above the cursor may have been updated 
with new results or just be values which were there in 2006.

the rows including the cursor row and below didn't have values in 2006 and 
have been inserted on 28-apr-2020 

The issue is caused by the actual mill roll number recycling in the plant 
system (don't ask why) and the application which fills this table and 
others not realising that this is an old mill roll.

The data clearly should be archived off occasionally and there is a good 
reason why this didn't happen. 

So here is the question - I / we assumed that rows inserted  (after 
28-apr-2020) would have a recent tuple id but if we look at the table it's 
clear they don't.
We are pretty sure that the answer to our question - Is there a way of 
working out when these rows came into the system? - is that there isn't 
but we decided to ask anyway.  It surprised me that the tids were 
sequential. 

The tuple ids for rows which have genuinely been added recently are 
considerably higher than the ones in this table. 

BTW a quirk of the plant system means that  not every new mill roll after 
a certain time is a duplicate. In fact very few overlap. 

If anyone has any ideas ........... 

thanks
Allan & Benoit 
--------------------------------------
This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean
------------------------------------
http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200528/e2189ea4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 77630 bytes
Desc: not available
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200528/e2189ea4/attachment.gif>