<html>
<head>
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/vnd.ui.insecure+html;charset=utf-8">
</head>
<body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">Thanks, Marty <br/><br/>I learned a long time ago to avoid tids. It was just odd that in this case they managed to create a sequence!<br/><br/><br/><br/>-- <br/>Sent from my Android phone with <a href="http://mail.com">mail.com</a> Mail. Please excuse my brevity.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em"><html><body>On 29/05/2020, 11:13 Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:</body></html><blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Is the database journal enabled? Is the table journal enabled?</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">If yes to both then auditdb is your friend. You can execute this on a specific table and will then see all the insert, update, delete traffic on the table over the time window chosen.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">This should give you the data you need to determine what the recent additions have been.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Marty</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">PS. NEVER rely on tids.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Allan Biggs <Allan.Biggs@GBR.dupont.com> <br> <b>Sent:</b> 28 May 2020 16:40<br> <b>To:</b> info-ingres@lists.planetingres.org<br> <b>Subject:</b> [Info-ingres] Fw: tid and the date a row originally came into a table</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:purple">----- Forwarded by Allan Biggs/GB/CONT/DPT on 28/05/2020 16:39 -----</span> <br> <br> <span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">From: </span><span style="font-size:7.5pt;font-family:"Arial",sans-serif">Allan Biggs/GB/CONT/DPT</span> <br> <span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">To: </span><span style="font-size:7.5pt;font-family:"Arial",sans-serif"><a href="mailto:openroad-users@googlegroups.com">openroad-users@googlegroups.com</a>, "<a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a>" <<a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a>></span> <br> <span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">Date: </span><span style="font-size:7.5pt;font-family:"Arial",sans-serif">28/05/2020 16:07</span> <br> <span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">Subject: </span><span style="font-size:7.5pt;font-family:"Arial",sans-serif">Fw: tid and the date a row originally came into a table </span></p>
<div class="MsoNormal" style="text-align:center">
<hr style="color:#A0A0A0">
</div>
<p class="MsoNormal"><br> <br> <br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">A colleague has an issue with data being overwritten and some inserted by a feed from a plant system.</span> <br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">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.</span> <br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">the rows including the cursor row and below didn't have values in 2006 and have been inserted on 28-apr-2020 </span><br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">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.</span> <br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">The data clearly should be archived off occasionally and there is a good reason why this didn't happen. </span><br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">So here is the question -<b> 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.</b></span> <br> <b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">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. </span></b><br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">The tuple ids for rows which have genuinely been added recently are considerably higher than the ones in this table. </span><br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">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. </span><br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">If anyone has any ideas ........... </span><br> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">thanks</span> <br> <span style="font-size:10.0pt;font-family:"Arial",sans-serif">Allan & Benoit </span> <br> <br> <img width="665" height="649" style="width:6.927in;height:6.7604in" id="_x0000_i1026" src="Attachment/Y2lkOmltYWdlMDAxLmdpZkAwMUQ2MzVBQS4xQTcxM0VCMA"></p>
<p><br> This communication is for use by the intended recipient and contains<br> information that may be Privileged, confidential or copyrighted under<br> applicable law. If you are not the intended recipient, you are hereby<br> formally notified that any use, copying or distribution of this e-mail,<br> in whole or in part, is strictly prohibited. Please notify the sender by<br> return e-mail and delete this e-mail from your system. Unless explicitly<br> and conspicuously designated as "E-Contract Intended", this e-mail does<br> not constitute a contract offer, a contract amendment, or an acceptance<br> of a contract offer. This e-mail does not constitute a consent to the<br> use of sender's contact information for direct marketing purposes or for<br> transfers of data to third parties</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> <a href="http://www.DuPont.com/corp/email_disclaimer.html">http://www.DuPont.com/corp/email_disclaimer.html</a></p>
</div> _______________________________________________ Info-ingres mailing list Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
</blockquote></div></body>
</html>