<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
If you need a unique, arbitrary ID for each record in your tables -- which
is almost always a good thing to have, the OID does the job automatically.
It has the additional benefit of being unique in the entire database. The
only problem I have is if records are imported from other databases, in which
case the OID is changed or at risk of being duplicated. If you assign your
own unique ID you can ensure that merged records preserve their ID. I advise
using the unique ID only internally and never having a user enter or reference
it.<br>
<br>
Jodi Kanter wrote:<br>
<blockquote type="cite"
cite="mid01e701c24563$00413ef0$de138f80(at)virginia(dot)edu">
<meta content="text/html; charset=iso-8859-1"
http-equiv="Content-Type">
<meta content="MSHTML 5.00.3315.2870" name="GENERATOR">
<style></style>
<div><font face="Times New Roman">Does anyone have a comment on the email
below? Is there a general consensus on whether or not to use OIDs with version
7.2?</font></div>
<div><font face="Times New Roman">Thanks</font></div>
<div><font face="Times New Roman">Jodi</font></div>
<div> </div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-stretch: normal; font-size-adjust: none;">-----
Original Message -----
<div style="background: rgb(228,228,228) none repeat scroll 0%;"><b>From:</b>
<a href="mailto:jkanter(at)virginia(dot)edu" title="jkanter(at)virginia(dot)edu">Jodi
Kanter</a> </div>
<div><b>To:</b> <a href="mailto:pgsql-admin(at)postgresql(dot)org"
title="pgsql-admin(at)postgresql(dot)org">Postgres Admin List</a> </div>
<div><b>Sent:</b> Friday, August 16, 2002 10:19 AM</div>
<div><b>Subject:</b> OID</div>
</div>
<div><br>
</div>
<div><font face="Times New Roman">Can anyone point me to some documentation
on the use of OIDs? Why might I need them? How to remove them in version
7.2? ..etc...</font></div>
<div><font face="Times New Roman">Thanks</font></div>
<div><font face="Times New Roman">Jodi Kanter</font></div>
<div>
<div class="Section1">
<p class="MsoNormal"><i><span
style="font-family: Arial; font-size: 9pt;">_______________________________<br>
</span></i><i><span style="font-size: 10pt;">Jodi L Kanter<br>
BioInformatics Database Administrator<br>
University of Virginia<br>
(434) 924-2846<br>
<a href="mailto:jkanter(at)virginia(dot)edu">jkanter(at)virginia(dot)edu</a></span></i><span
style="font-family: Arial; font-size: 11pt;"><br style="">
<br style="">
<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family: Arial; font-size: 11pt;"> <o:p></o:p></span></p>
<p class="MsoNormal"><i><span
style="font-family: Arial; font-size: 9pt;"> <o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span
style="font-family: Arial; font-size: 9pt;"> <o:p></o:p></span></i></p>
</div>
</div>
</blockquote>
<br>
</body>
</html>